Current Position:Home > How to Call PL/SQL Procedure

How to Call PL/SQL Procedure

Update:10-11Source: network consolidation
I am trying to call PL/SQL Procedure in OCI but i didn't get success, Please answer,
Thank you in advance

The Best Answer

Here is a very short sample. Hope it helps
char SQLStatemen[] ="BEGIN spFoo (:P_Name);END;";
/* Initialize everything */
OCIBindByName (CommandHandler, &OCIBindName, ErrorHandler, (text *) ":P_Name", -1, (dvoid *) Name, strlen(Name) +1, SQLT
_STR, (dvoid *) 0,(ub2 *) 0, (ub2 *) 0, (ub4) 0, (ub4 *) 0, OCI_DEFAULT) == OCI_ERROR);
OCIStmtExecute (ServiceContext, CommandHandler,ErrorHandler, 1, 0, (OCISnapshot *) NULL,(OCISnapshot *) NULL, OC
/* if P_Name is an out parameter, at this point, it has the value it got from the database */
/* logoff and close everything */
  • Unable to capture the parameter values from a PL/SQL procedure Update:10-11

    hi. i'm trying to capture the parameter values of a PL/SQL procedure by calling inside a anonymous block but i'm getting a "reference to uninitialized collection error" ORA-06531. Please help me regarding. i'm using following block for calling t

  • How to call a PL/SQL procedure from a Java class? Update:10-11

    Hi, I am new to the E-BusinessSuite and I want to develop a Portal with Java Portlets which display and write data from some E-Business databases (e.g. Customer Relationship Management or Human Resource). These data have been defined in the TCA (Trad

  • How to call a PL/SQL procedure from a xml Data Template Update:10-11

    We have a requirement in which we need to call a pl/sql package.(dot)procedure from a Data Template of XML Publisher. we have registered a Data Template & a RTF Template in the XML Publisher Responsibility in the Oracle 11.5.10 instance(Front End). I

  • How to call a PL/SQL procedure from Portal Update:10-11

    Env.Info: Windows NT Server 4 (Service Pack 3) / Oracle 8i R3 EE / Oracle Portal 3.0 Production. I created a new schema "BISAPPS" and created a user with the same name. Ran provsyns.sql script to grant Portal API access. Created a new package un

  • How to send a java array to a pl/sql procedure Update:10-11

    Hi, This is similar to a post about 6 months ago on retrieving pl/sql tables from a java application but I can't seem to figure out how to use what I learned there to solve this. In a java application I have a Long[] array, and in the database I have

  • How to get data from URL in a PL/SQL procedure Update:10-11

    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

  • How to secure a PL/SQL procedure that is called from the web browser Update:10-11

    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

  • Error when try to call a pl/sql procedure from the .xsql file Update:10-11

    I tried to call a pl/sql procedure like this: <?xml version="1.0"?> <page connection="omtest5" xmlns:xsql="urn:oracle-xsql"> <xsql:include-owa> sampleowaxml.testone </xsql:include-owa> </page> bu

  • How to pass multiple parameters while calling a pl/sql procedure based serv Update:10-11

    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

  • Obtaining HTML page by issuing a call from a PL/SQL procedure Update:10-11

    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,p_flow_step_id=>'2',p_flow_id=>'104') and i try to read the result