Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Invoke stored function from Pro*C
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. Received on Fri Jul 08 2005 - 19:00:24 CDT