Discussion
Virtusa
IN
Last activity: 6 Apr 2018 19:26 EDT
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.
Apple India Pvt Ltd
IN
Hi SaiSureshY ,
First can you please check your column size in your database table. Initially if you use varchar for your table column, by default it can take 256 chars. So if you send more than 256 chars it will not accept. So better we if you use text as a data type for your table coulmn.
Thanks
Bala Gangadhar P
Virtusa
CA
SaiSureshY:- This issue is with the parameter which is being passed from Pega to Stored Procedure. It is not a SQL issue. Standalone Stored Procedure works fine.
Tata Consultancy Services
IN
SaiSureshY: May be you can try this.
1. In the activity write a java step inside which get the property value which is having entire XML Data into a Stringbuffer.
2. Create the DB connection in java step. something like this.
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
3. Hit the stored proc.
It's not a recommended approach. :)