Stored Procedures which return structures

[James Spibey]

Hi,

I am trying to call an Oracle 8 stored procedure which has a structure as its output parameter.

Has anyone had any experience of doing this? I assume I will need to define a new RFX function to handle the conversion but I am not exactly sure of how to go about it.

Also is it possible to get the definition of the structure from the procedure. For example in PL/SQL I would use the following code


EXEC SQL EXECUTE
declare
bpm_data router_pack.bpm_data;
begin
:sent_to_location:=
router_pack.lp_to_terminal(
:bag_index,
:licence_plate,
:scanner_id,
:scanned_date_time,
bpm_data);




Please help as I am really struggling to find any info on this

James