Re: avoid dynamic SQL
From: Edgar Chupit <chupit_at_gmail.com>
Date: Wed, 1 Jul 2009 16:56:08 +0200
Message-ID: <a8f0771c0907010756g66d38affme1be714d24354ab4_at_mail.gmail.com>
Yep, I have tried CONTEXT on 10g as well, same result as with bind variables (simple example):
Date: Wed, 1 Jul 2009 16:56:08 +0200
Message-ID: <a8f0771c0907010756g66d38affme1be714d24354ab4_at_mail.gmail.com>
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_at_gmail.com> wrote:
> Have you considered using CONTEXT variables?
>
> On Wed, Jul 1, 2009 at 6:45 AM, Edgar Chupit <chupit_at_gmail.com> wrote:
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 01 2009 - 09:56:08 CDT