Re: bind a CLOB in Dynamic SQL ?

On Jan 17, 5:56 am, "rios" <r..._at_rios.com> wrote:
> <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

Please refer to
http://www.psoug.org/reference/dbms_sql.html

-- 
Sybrand Bakker
Senior Oracle DBA