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!

Execute a DML query its length exceeds 4000 characters with execute immediate statement.

851511Jun 18 2013 — edited Jun 19 2013

I want to execute a DML query with execute immediate statement. That DML query length exceeds 4000 characters. This query has Xquery related conditions, i can not split the query. when i tried execute it is giving "string literal too long". I tried with DBMS_SQL.Parse() and DBMS_SQL.Execute also, but it is giving same error. I have to execute this DML query inside a Procedure. Please help me to resolve this. We are using oracle 10g version

Thanks & Regards,

K.Kedarnadh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2013

Added on Jun 18 2013

#query

22 comments

14,260 views