Re: Connect to another user in pl/sql block

I hate doing this (bc I tend to it alot), but what are you trying to accomplish by doing this??

Let me get a better idea of what you are trying to do...

In article <8o3ids$gci$1_at_kermit.esat.net>,   "Joanna C" <joannac_at_peregrine.ie> wrote:
> hi guys,
>
> I need to connect to another user inside a pl/sql block. Eg. I am
 userA. In
> the pl/sql stored procedure, I need to then connect as UserB. By doing
 so, I
> will be running a UserB session rather than UserA.
>
> Is there a way of solving this problem?
>
> I know we can do CONNECT <username>/<Password>@<SID> in sql*plus.
>
> I do not know how to do it through pl/sql stored procedure.
>
> Using DBMS_SQL does not help. Is there any Oracle package which I can
 use?
>
> Any assistance is greatly appreciated.
>
> Thank you
>
> Regards,
> Joanna
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 24 2000 - 12:04:54 CDT