Re: Invoke stored function from Pro*C

On Sat, 09 Jul 2005 08:00:24 +0800, Poh Tien Lye interested us by writing:

> I am trying to invoke a function stored on Oracle
> using Pro*C. However, the precompiler does not
> compile through. I have attached the code below:
> EXEC SQL EXECUTE
> BEGIN
> :nRefNum := getRefNo(szProductCode);
> END;
> END-EXEC;
>
> getRefNo() is the function in the database.
> a string is passed to the function and it returns
> an integer.
>
> Thanks in advance.

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a97269/pc_07pls.htm#8703

Assuming you want assistance, instead of just a document reference, please consider providing Oracle version, and any messages from the compiler, are usually relevant information - "precompiler doesn't compile through" is generally meaningless to me.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***