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

Home -> Community -> Usenet -> c.d.o.misc -> Invoke stored function from Pro*C

Invoke stored function from Pro*C

From: Poh Tien Lye <pohtl_at_singnet.com.sg>
Date: Sat, 9 Jul 2005 08:00:24 +0800
Message-ID: <dan1fg$il5$1@reader01.singnet.com.sg>


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

Original text of this message

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