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 Immediate Query Size

679196May 25 2009 — edited May 26 2009

Hello,

The EXECUTE IMMEDIATE only takes a NVARCHAR2 or VARCHAR2 parameter (which has a max length of 4000),

i need to send a parameter with a larger length (XML Representation of Columns and their values) but im restricted with nvarchar2 or varchar2...

what can i do to send a large text value to the EXECUTE IMMEDIATE method.

Thank you ...

Basem Sayej

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2009

Added on May 25 2009

8 comments

948 views