Skip to Main Content

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!

String literal too long

Sanjay MKSep 19 2024 — edited Sep 20 2024

Hi,

I'm facing the string literal too long issue and I have shared the select query, if I run the below query, I'm getting error. Please check and share you ideas.

select substr('<very long string of 5667 character - removed by forum moderator as it contained content that could be considered spamming….>,',1,4000) tst from dual;

Thanks,

Sanjay

Comments
Post Details
Added on Sep 19 2024
18 comments
1,346 views