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!

apex_string.string_to_table giving ORA-00902: invalid datatype

Mr.PeabodyApr 10 2021 — edited Apr 10 2021

I want to convert colon delimited list into separate rows. I am passing col1 VARCHAR2(4000) to apex_string.string_to_table.

select (select column_value from table(apex_string.string_to_table(col1))) from tab1;

getting ORA-00902: invalid datatype.
Thanks!!!

This post has been answered by Hub Tijhuis on Apr 10 2021

Jump to Answer

Added on Apr 10 2021

#apex, #plsql, #sql, #sqldeveloper

8 comments

938 views