EXTPROC query : HOWTO return a string/VARCHAR2 from a C/C++ EXTPROC into a PL/SQL function

The Oracle documentation clearly shows how to write an external routine and return a NUMBER in an PL/SQL function - see the link below.

http://my.kharkov.org/docs/oracle/nt.816/a73008/ch11.htm#1053465

I cannot find an example anywhere on how to return a string (as a VARCHAR2) from a function.

Anyone have a C/C++ example on how to do this, or a hyperlink to somewhere that shows an example. I am guessing that you have to return a pointer to an OCIString but am a bit lost here.

Thank you
Barry Received on Sat Aug 23 2003 - 12:40:05 CDT