Toad World® Forums

How to see object type output in TOAD

Hi,

I have written a procedure and one of the parameter returns a OBJECT, sample below.

Sample Procedure:

CREATE OR REPLACE PROCEDURE TEST (
IN_PYMNT_ID IN TEST_TABLE.PAYMENT_ID%TYPE,
OUT_HEADER_DATA OUT TY_PAYMENT_DETAILS_OBJ_TBL,…

Sample Object:

CREATE OR REPLACE TYPE ty_payment_details_obj AS OBJECT
(FIELD_NAME VARCHAR2(300) ,
FIELD_VALUE VARCHAR2(300) );
/

Sample Table:

CREATE OR REPLACE TYPE TY_PAYMENT_DETAILS_OBJ_TBL IS TABLE OF ty_payment_details_obj
/

How to execute the procedure and view the resultset passed into this OUT variable in the data grid(similar to refcursor resultset)

I’m using TOAD 10.6.1.3 version

Thanks

Any updates on the above query? Do we have any option to execute procedure with object as n output type in TOAD 12 version?

What about this. Execute with F9. When prompted set the datatype of the bind var to cursor.

declare

data TY_PAYMENT_DETAILS_OBJ_TBL;

cur sys_refcursor;

begin

test(data);

open cur for select * from table(data);

:data_out := cur;

end;

So this means there is no straight forward option available in TOAD to directly get the object OUTPUT? But thank you much Michael for this workaround… Am surprised why TOAD does not have this cool feature which is available in free tools like PLSQL developer…