Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Change SCHEMA in Stored Procedure
How do you change the SCHEMA name in a stored procedure? Below are snippet of
my code. I try using ALTER SESSION SET, but having problems. What's the solution.
CREATE OR REPLACE PROCEDURE test (schema_name IN VARCHAR) AS
/** Define variables **/ CURSOR a IS SELECT * FROM A; BEGIN
.
.
ALTER SESSION SET current_schema = schema_name;
.
.
![]() |
![]() |