Re: avoid dynamic SQL

From: Edgar Chupit <chupit@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 1 Jul 2009 16:56:08 +0200

Yep, I have tried CONTEXT on 10g as well, same result as with bind
variables (simple example):

SQL>    select XMLQuery(SYS_CONTEXT('USERENV','SESSIONID') returning
content).getnumberval() result
  2        from dual
  3  /

select XMLQuery(SYS_CONTEXT('USERENV','SESSIONID') returning
content).getnumberval() result
      from dual

ORA-19102: XQuery string literal expected

But this works fine:

SQL>    select XMLQuery('1231241' returning content).getnumberval() result
  2        from dual
  3  /

    RESULT
----------
   1231241



Best regards,
 Edgar Chupit
 callto://edgar.chupit



On Wed, Jul 1, 2009 at 4:50 PM, Michael Moore<michaeljmoore@xxxxxxxxx> wrote:
> Have you considered using CONTEXT variables?
>
> On Wed, Jul 1, 2009 at 6:45 AM, Edgar Chupit <chupit@xxxxxxxxx> wrote:
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: avoid dynamic SQL
From: Michael Moore

References:
- Re: avoid dynamic SQL
  - From: amonte
- Re: avoid dynamic SQL
  - From: Edgar Chupit
- Re: avoid dynamic SQL
  - From: Michael Moore

Re: avoid dynamic SQL

Other related posts: