Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> bind a CLOB in Dynamic SQL ?
<10gR2>
Can you bind a CLOB in dynamic SQL in PL/SQL ?
(dbms_sql, Native dynamics)
like (line#2):
SELECT extractvalue(VALUE(x), 'Account_No') account_no FROM TABLE(xmlsequence(extract(sys.xmltype(:the_clob), '/TheRoot/Alpha/Bravo/'Account_No'))) pl;
thanks Received on Tue Jan 16 2007 - 22:56:00 CST
![]() |
![]() |