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 -> Re: alter session set current_schema

Re: alter session set current_schema

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Fri, 15 Jan 1999 21:01:58 GMT
Message-ID: <369fac62.498609722@news.cyberus.ca>


This is a neat little feature, but If I'm not mistaken it's not supported. Be careful.....

Robert Prendin
"Gerard H. Pille" <ghp_at_skynet.be> wrote:

>This works from an sqlplus session, but is it possible to use this from
>within forms? dbms_session doesn't seem to provide it, and I've tried
>using dynamic sql, but it doesn't seem to work (I get ORA-924 for tables
>which are known from within the schema)
>--
>Kind Regards,
>
>Gerard

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Fri Jan 15 1999 - 15:01:58 CST

Original text of this message

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