Saisvirtusa Member since 2014 3 posts
Posted: 4 years ago
Last activity: 4 years 10 months ago

Unable to pass large String text (XML) from Pega Connect SQL Rule to Oracle Database.


We are trying to call a stored procedure GetValues_SP from a Connect SQL rule in the application.

The stored procedure is defined in an Oracle database.

The Connect SQL sends a Text property (containing an XML string) as a parameter to the procedure as a CLOB.

The declaration of the CLOB is happening inside the Stored Procedure.

The length of my String is pretty big (larger than 32K). Hence, I am getting the following error:-

PLS-00172: string literal too long

Anyone else encountered this before? Please advise on what might be going on here?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn