You can't, but you can use 'alter session set
current_schema = ...'. Similarly, if the procedure
you're building has all the power the create users/
create tables, then it will be able to put data in
that table, it can also be used to temporary create a
secondary procedure in the new schema to is
Dear DBA Gurus,
I want to create a stored procedure in which a name is passed as
input parameter. The procedure should take the name as input parameter and
create a user with the username and password same as name. Then I want to
connect as the newly created user and create a set of tab
