SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use connect/conn command inside a stored procedure

RAJKIRAN12May 18 2016 — edited May 18 2016

I have created a stored procedure called CREATE_USER with 6 in parameter .The purpose of the stored produce is to connect specific user and do some activity.

There are 3 conn command .Example : conn RAJKIRAN as sysdba/passw0rd123, conn amit/passw0rd. While compiling i am getting the following error:

Error(11,7): PLS-00103: Encountered the symbol "RAJKIRAN" when expecting one of the following: := . ( @ % ;

And also want to know how to disconnect from one user and switch to another user. Please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 15 2016

Added on May 18 2016

7 comments

1,518 views