Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> bind a CLOB in Dynamic SQL ?

bind a CLOB in Dynamic SQL ?

From: rios <rios_at_rios.com>
Date: Tue, 16 Jan 2007 23:56:00 -0500
Message-ID: <12qrb31ppsrae41@corp.supernews.com>


<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US