Discussion

4
Replies
380
Views
Close popover
Sai Suresh Yaramati (Saisvirtusa)
Virtusa

Virtusa
IN
Saisvirtusa Member since 2014 3 posts
Virtusa
Posted: September 29, 2015
Last activity: April 6, 2018
Closed

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

Hi,

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.

System Administration Upgrades
Moderation Team has archived post