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
Hi, I made a vi to take images and save it in a file in a While loop (run it every 3 sec.). The images are saved to files whose filenames will increment by one. The problem is that it only can save 10 files. After that nothing is saved. I attach the [More]
We just switched to an HP printer and now we are having issues printing. We are working in InDesign CS5.5, on a Mac and when we try to duplex it prints the first page and then the second page prints separately and all black, almost like the connectio [More]
The window just ends right below the slide bar. I tried closing the window and reopening it, even restarting the computer, but it didn't fix it. At first I thought the window was too big, so I tried resizing it, but it didn't work.You have out-of-dat [More]
My serial number is not accepted, how to proceed  (my card says: ActivationCode, should I have a separate serial number?)Hi, back again,     Sorry for not responding to the previous remarks. Here is the case: I bought a license in the university shop [More]
I have a project which has a primary layer formed of imported JPGs that are in sequence. These are shots from a time lapse and are sequentially named and imported without issue into Premier Pro. I then have a secondary layer with a simple After Effec [More]
Hi I have a procedure which has 3 input parameters and 1 REF CURSOR type OUT parameter.   In the body of the procedure a select query is dynamically being created, and just before the end of the procedure the REF CURSOR is opened for SELECT(dynamic) [More]
Hi Gurus, We have two costing variant. One standard variant(PPC1)  is to update in Material master as standard price. Another one it need to update in the Tax price in material master as reference for sales. We created seperate varaint to update in t [More]
Hello everyone, I am not able to reproduce something so I thought I would ask here. In FB01, you can have many things that gives you a mistake if the input is wrong. Though, if you run the transaction FB01 in a batch input, how many mistakes per tran [More]
I have icloud. I have backed up my photos from my iPhone 5 to my iPad. Can I now delete the photos from my phone and they will stay on my iPad? I need to clear space in order to run an update.I get the following warning message when deleting a shared [More]
Need help. I have an EOS 30D and 50D but I cannot view then in Digital Photo Professional. Ok in Zoombrowser. But in Adobe Bridge, some are viewable, others not. Had no troble until I had to reinstall programmes due to corrupt Registry. Had to do a t [More]