Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Calling a stored function from PROC

Calling a stored function from PROC

From: <gjs_at_hotmail.com>
Date: Wed, 12 Aug 1998 14:41:23 -0400
Message-ID: <35D1E1D2.1121E6AC@hotmail.com>


I appreciate if any body can help me wit the following.

I wrote a small function and packaged it with other procedures which returns and integer v_result.

XYZ is package and ABC is the name of the function.

This has been tested by executing a small proedure where it takes in two parameters and returns the result. An I am pasting the error message I got while compiling the C program.

I am not sure how to invoke a function from the C program and capture the result.

Now I want to call this function from within a C program. I have declare the variables verA and verAC in the declare sections.

And executed as below.

 EXEC SQL EXECUTE
 BEGIN
         XYZ.ABC(:verA,:verAC);
  END;  END-EXEC;
   return(v_result);

returnStaus = v_result.

 129 END-EXEC;
 129 .^

     PCC-S-0061: Error at line 131, column 10. PLS-221: 'ABC' is not a proce
dure or is undefined
 129 END-EXEC;
 129 .^ Received on Wed Aug 12 1998 - 13:41:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US