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
I'm an old C programmer learning Java. As an exercise, I'm writing a fairly simple astronomy program, and one of the things it needs to do is to convert between two different coordinate systems, (altitude, azimuth) and (hour angle, declination). As i [More]
I had created an application which allows to upload an image for a row, basically based on what's done in the demo app for the products table. Today, I exported the app and then uninstalled Beta 2 and installed Beta 3. Installation finished without a [More]
Dear Firefox Community I want a longer text entry area in the search bar and a shorter text entry area in the location bar. How do I make this happen? I've looked at the customize Firefox notes and they don't address this (that I can find anyway ...) [More]
When I try to sync my music in iTunes, the selection "all songs and playlist" is not clickable. What has to be done to correct this? Thanks-Dan.Read other 2 answers [More]
After trying every possible solution proposed to resolve my wifi connection problems after upgrading to iOS6'the only solution left is to purchase another router. Today an Apple tech support rep told me wifi connection was hardware related only and h [More]
Hi, We receive a .dmp file from another company each night. The process changed when they started to obfuscate some sensitive data. But since then we are finding all the tables are missing their primary keys. I really would like to eliminate our impo [More]
We have upgraded to BI 7.0 SP13. When executing CRM reports they return no data. It appears that the variants are not being passed correctly to BW to extract the data. We have run all of the required programs to convert variants after upgrade. This i [More]
Hi everyone Is it true that we can have the add-in in one Excel instance only? (when I started my 2nd Excel, the OracleBI menu does not show up) djoniHi Yes, I'm afraid that is true. Sorry about that. Please don't shoot the messenger. If you don't li [More]
While trying to build WAR file, I get the error message Caught IOException in Jspc.putFilesIntoResultsFile():java.io.IOException. I am using the following command to build my WAR. java -jar ojspc.jar C:\appln.war -appRoot C: -addclasspath C:\applnejb [More]
Hi, we have views set up based on Audience memberships. I need to emulate a user's views, and want to place my account into the Audience they're in. Can /_layouts/Audience_List.aspx be searched by user account? Thanks, ScottNot out of the box as far [More]