SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL dbms_output.put_line entry from a table type

dunmic19Mar 4 2022

I have the following defined in a package spec (ssan3102):
TYPE ssan3_stringarray IS TABLE OF VARCHAR2(2000) INEX BY BINARY_INTEGER;
And the following defined in a procedure.
keys ssan3102.ssan3_stringarray;
A call to a C library populates keys. How can I use dbms_ouput.put_line to display the entries in the table? Each entry is 8 bytes.
Thanks

Added on Mar 4 2022

6 comments

1,457 views

1 mention