I doubt it... but this could save me from coding it into a unix script and keeping all
my code in my package. I tried
execute immediate 'connect user/password; and it failed.
is this doable?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET:
My guess is that 'connect' is a sql*plus command (rather than a pl/sql command) & so
wouldn't work with execute immediate.
But maybe you could break out the portions of your code that need to run as a
different user into a separate package, owned by that user?
HTH,
-Roy
Roy Pardee
Programmer/
I think that there are two reasons to do it:
1) You need permissions that are granted to another user
2) You need to work in another schema and you have permissions to these
objects.
In 1) you can grant yourself the necessary permissions.
in 2) try execute immediate 'alter session set current sch
ate: 2003/08/20 Wed PM 01:24:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: possible to dynamicly connect to a different user in pl/sql?
>
> My guess is that 'connect' is a sql*plus command (rather than a pl/sql command) & so
&