Sitemap

Amicuk Programming Answers

Index > sql procedure in process chains >

sql procedure in process chains

Advertisement

PL/SQL procedure to process XML file

Category:DefaultRelease time:2015-10-11Views:130

I am just starting to work on xml, and we are using PL/SQL stored procedures to process xml file. I did find the sample code in the package (family.sql). This sample print out all element names and attributes. My questions are : (1) I tried to modify[More]

Run/Schedule HANA Procedure via Process Chain or Similar - BW on HANA

Category:DefaultRelease time:-0001-11-30Views:130

Hello Experts, We have BW 7.4 on HANA database(rev 74). We are working on mixed scenario approach. We have few of the stored procedure in HANA. We want to schedule it. Is there any way to schedule it via BW process chain or any similar thing? Thanks[More]

PL/SQL Procedure and Java

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I am working on a Data Warehousing Product and generating Web Reports. These Web Reports are JSPs. The basic architechture used for this is : 1. Get the inputs required for Report Generation through a Web GUI 2. Validate and Process (If Valid[More]

Invoking a BPEL process from a PL/SQL procedure(URGENT)

Category:DefaultRelease time:2015-10-11Views:130

hello, Is it possible to invoke a BPEL process from a pl/sql procedure?? Please reply ...Yes it is. On my current project i needed this too. http://orasoa.blogspot.com/2006/11/calling-bpel-process-with-utldbws.html Re: Error running demo PL/SQL consu[More]

Procedures for implementing Process chain

Category:DefaultRelease time:-0001-11-30Views:130

Hai, Can any help me to know the step by step procedure to implement process chain in BW. Regards, Girihi, refer to this link. http://help.sap.com/saphelp_nw2004s/helpdata/en/8f/c08b3baaa59649e10000000a11402f/frameset.htm hope it helps, regards, Part[More]

Process chain detailed step procedure

Category:DefaultRelease time:-0001-11-30Views:130

dear all,     i want detailed step procedure or tutorial about process chain for beginners. i need help. with regards, satish.Hi, Please search the forum before posting : http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/502b2998-1017-2d10-1c8a-[More]

Linking PL\SQL procedure as Concurrent Process

Category:DefaultRelease time:-0001-11-30Views:130

Hi. I'm link PL-proc as concurrent process, and it runs without any errors. Now I need also run it as standart report, but can't generate output file to store any words to. help. mailto: [email protected]Thanks for your response. I am writing a BPEL[More]

SAPSQL_ARRAY_INSERT_DUPREC during saving of Process Chain

Category:DefaultRelease time:2015-10-11Views:130

Dear all, On saving, when adding a process to an existing Process Chain - like Rollup or Change Run - in our SCM 5.0 system, we receive a short dump 'SAPSQL_ARRAY_INSERT_DUPREC' (complete short dump at the end of the msg). A problem arose on the line[More]

"Syntax error in the MDX statement " in Process chain failure??Urgent pls

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, could any one suggest me the procedure to rectify the below problems in process chain? 1."Syntax error in the MDX statement " 2."Error when getting data (Error when getting data (AXI))" Rgds, BHIn which case it'll be that A[More]

403 Forbidden error calling PL/SQL Procedure from URL

Category:DefaultRelease time:-0001-11-30Views:130

I am getting a 403 Forbidden browser error when calling a PL/SQL procedure from the URL, as in this: http://<server.port>/apex/SCHEMA.procedure_name/f?p_param1=394&p_param2=2, etc We are upgrading from HTMLDB 2.0 to APEX 4.0.2. I do not believe[More]

Process Chain Cancelling in Background Process

Category:DefaultRelease time:-0001-11-30Views:130

Hello Experts, In our production system Process Chain is canceling in background process. Please tell me the reason and how to solve this issue. Details of Process Chain Background Job 1. BI_PROCESS_TRIGGER Job Step No. Program name/command Prog. typ[More]

Short dump in program to trigger process chain

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, We have an ABAP program written to trigger a process chain...When we execute the ABAP program it goes on for a long time and then returns a short dump.It dosent even trigger the process chain. What could be the reason for this? Can someone pl[More]

Process Chain Error    DBIF_RSQL_INVALID_RSQL

Category:DefaultRelease time:-0001-11-30Views:130

Hi, One of my process chain has an error. The PChain has this nodes: - Start - Data loader     (to ODS) - Data Transfer Process to ODS - Activate - Drop Cube Indexes - Data Transfer Process to Cube - Generate the Cube Indexes but... the process mark[More]

Process chain - ODS Activation error

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, I have a process chain which has the following data load sequences: Load data to ODS Activate ODS Load data to ODS2 Activate data ODS2 Load data to ODS3 Activate ODS3. Used the Program to RSPC_SYNCHRONOUS_RUN to schedule the process chain[More]

How to get data from URL in a PL/SQL procedure

Category:DefaultRelease time:2015-10-11Views:130

Hi!<br> <br> I want to pass values in APEX from a report with a link to a PL/SQL procedure through URL. How can I make this?<br> <br> For example:<br> <br> I have a report:<br> <br> select<br>    id,&l[More]

How to secure a PL/SQL procedure that is called from the web browser

Category:DefaultRelease time:2015-10-11Views:130

If you have ever seen the sample document management application, and tried to download a file that was stored in the system, you are probably familiar with the apex_util.count_click URL that is used to download the file. If you copy that URL and pas[More]

How to pass multiple parameters while calling a pl/sql procedure based serv

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a pl/sql procedure based service that needs to be invoked from the bpel console for testing purpose. This procedure accepts multiple input values which are of varchar2,boolean and datetime data types. How can I get the bpel console to thro[More]

Obtaining HTML page by issuing a call from a PL/SQL procedure

Category:DefaultRelease time:2015-10-11Views:130

Is there any possibility to obtain HTMLDB -> HTML page from a user defined PL/SQL procedure ? For example I build an procedure which calls directly flows_010500.wwv_flow.show(null,p_flow_step_id=>'2',p_flow_id=>'104') and i try to read the result[More]

PL/SQL procedure is 10x slower when running from weblogic

Category:DefaultRelease time:2015-10-11Views:130

Hi everyone, we've developed a PL/SQL procedure performing reporting - the original solution was written in Java but due to performance problems we've decided to switch this particular piece to PL/SQL. Everything works fine as long as we execute the[More]

Passing variable of size greater than 32767 from Pro*C to PL/SQL procedure

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to pass a variable os size greater than 32767 from Pro*C to an SQL procedure.I tried assigning the host variable directly to a CLOB in the SQL section but nothing happens.In the below code the size of l_var1 is 33000.PROC_DATA is a pr[More]

Hot
Where would I go to find out why some of this site doesn't display properly on my computer? At least I think it's not right--the font in the tabs at the top and some type at the bottom are outlined and hard to read.Somebody gave an explanation of wha [More]
When i set the formula like below reportDocument.DataDefinition.RecordSelectionFormula = {HCPT.HCPID} = {HCP.HCP_ID} AND {HCPT.TERR_ID} = {DBINFO.TERR_ID} AND {VW_RXTERR.PROD_ID} IN ('07Q2','07PT') AND {VW_RXTERR.MEAS_ID} ='1' AND {VW_RXTERR.PLAN_ID} [More]
Well, whenever I open a flash player, or something like that, most things that use flash player as a plugin, it freezes my firefox, and then, after awhile it may or may not say a script is causing problems yadda yadda.If you are running Flash 11.3, t [More]
I am trying to use the html:link but the page value is dynamic (resulting from the bean within the iterate tag). The code below doesn't work - error. Is there a way to use all Struts tags and make this happen. Any ideas?         <logic:iterate id=" [More]
An exception occurred that is explained in detail below. The exception, which is assigned to class 'CX_SY_REF_IS_INITIAL', was not   caught and therefore caused a runtime error. The reason for the exception is: Es wurde versucht mit einer 'NULL' Obje [More]
I have produced three documents in Pages all with the same styles, etc. One of the documents prints out as if it was being bound. I've made sure all the facing pages, etc. settings are not invoked. Any idea why I'm getting that?Welcome to Discussions [More]
iTunes Error Message 'The iTunes Library file cannot be saved. An unknown error occurred (-50).  How do I correct this error?I know this doesn't help you Bud, but I've had this issue for at least the last couple of versions.  If I can ask, what is yo [More]
I wrote a trigger with a cursor but it generate following msg and focused on FOR EACH ROW line while compiling any help PLS-00801: internal error [ph2csql_strdef_to_diana:bind] CREATE OR REPLACE TRIGGER ERPTRAIN.TRG_ADM_USER_UPDATE AFTER INSERT OR UP [More]
Has anyone ever used aso cube to aggregate data and put it into a datawarehouse? We are exploring the option of using essbase ASO's to aggregate data from a fact into summary form then loading the required data via dataexport in version (9.3.1) OR (9 [More]
I am running a Mac Pro with the Nvidia graphics card. I did boot camp to intall windows, but later decided to remove the partition adn install parallels. The problem is thaton the mac side when I place a monitor on the second port, all my screens do [More]