Hi,
There is a procedure in Informix that returns data with resume. Which is kind of equivalent of pipelined function in oracle.
When we execute this from Universal editor, Informix returns n columns n rows as per the return statement of the procedure.
Is there any way to call it from within Oracle SQL Developer? I have tried to code it as below block though I know it wont work as there are no arrangements to receive the records/columns returned by the Informix procedure.
----------------------------------------------------------------
DECLARE
result VARCHAR2(20);
result1 VARCHAR2(20);
BEGIN
dbms_output.enable;
result := DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@dblink_to_informix('execute procedure cpst(''0'',''4RCD0232KC1ZATG%'') ');
dbms_output.put_line (result);
END;
/
----------------------------------------------------------------
Do we have to use procedure DBMS_HS_PASSTHROUGH.EXECUTE_NON_QUERY?
Or do we have to use a cursor using the OPEN_CURSOR, BIND_CURSOR, BIND_VARIABLE, CLOSE_CURSOR, etc. from package DBMS_HS_PASSTHROUGH?
In that case how to receive/retrieve the records /columns returned by the Informix procedure?
How to use the GET_VALUE_RAW procedure? I did not find any example for the same in all the documentation or even on the net.
Thanks in advance
Abhivyakti