Skip to Main Content

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!

ORA-06536: IN bind variable bound to an OUT position

425442Aug 9 2004 — edited Aug 9 2004
I am trying to execute following from pl/sql but keep getting ORA-6536 any help would be useful

retsql = 'Update ABC set X = empty_clob() where param=:1
RETURNING out_doc into :2' ;

execute immediate retsql USING param1, param2;

param2 is a global defined as an output parameter, not quite sure why this error should come

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2004
Added on Aug 9 2004
1 comment
3,434 views