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
At first I use PHP to generate xml output on page then use the data to my httpservice with resultformat e4x. Everything is fine. But now I want to use coldfusion script since I'm planning to use ColdFusion as my web server. I have this script located [More]
Hello, I have a swing application launched on the client with the help of Java web start. The applications works fine in jre 1.4 and jre 1.5. The heap sizes are : initial-heap-size="5m" max-heap-size="24m" But when I run this using jre [More]
heres what happened. I have the trial of 2.1 and i have importing many photos which has worked fine and i love the program. Today i went to import some photos from a shoot and in the middle of the import the camera got unplugged...oops. Now when i op [More]
What gives with this software? I've read on these forums that people have plugged in a FW/USB disk directly into their laptops, done an initial backup and then plugged the disk into either an AEBS or another Mac running Leopard and are happily, wirel [More]
My Adobe Presenter 9.02 Build 173 has suddenly developed a problem where recording video from within PowerPoint has stopped working. I have Office 2013 32-bit and Windows 8.1 64 bit. I believe that Presenter installed itself automatically in the inst [More]
how do I import an iMovie HD project to my new Final Cut Pro X from an external hard drive?Any replies to this one? Anyone????Read other 2 answers [More]
When i start and stop MS XL ,it give me this error message i chicked help and got this Compile error in hidden module: <module name> A protected module can't be displayed. This error has the following cause and solution: There is a compilation error [More]
Hi Experts, We are trying to apply Support pack on netweaver java stack using JSPM. While applying we are getting below error. I have attached deploy_api.0.log also. Can any one tel how to resolve this issue. Thanks & Regards, Jithin MHi Sriram, As p [More]
I've just recently found the wonderful Adobe Illustrator exchange resource, but the files I download open as blank pages??? Can anyone help me understand what's going wrong. I'm using CS3 on G5 Mac...If the files you're downloading are brushes or pat [More]
Hi, im new to j2ee and there are some qns i hope you can help me with. 1. why is there a need to put my jsp and servlets in a .war file? 2. where do i do my placements of ejb and jsp into the respective jar and war files? in my web server? thanks a l [More]