Re: Can ProC read a PL/SQL user defined record structure?

Hi Kelvin:

Maybe I am wrong. I don't think it can be done. The communication between PL/SQL and C is dbms_pipe. I think dbms_pipe is limited to simple data type e.g. VARCHAR2, NUMBER, DATE etc..

If you have found something, please let me know.

Best regards,

Kelvin.Stingel_at_ubs.com wrote:
: Hi,
 

: Is it possible to code an (user defined ) PL/SQL record in a stored
: procedure then pass that record as an OUT parameter into the C code
: filling a host array.
: If Yes then take it 1 step further and say that the PL/SQL Record
: contains PL/SQL tables and another PL/SQL Record, so that the PL/SQL
: records are nested.
: Has anybody got this working?
 

: regards
: Kelvin

--
Best regards,