Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter session set current_schema
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
![]() |
![]() |