Connect to another user in pl/sql block

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 Received on Thu Aug 24 2000 - 11:36:03 CDT