|
-
DECLARE
/*
|| Procedure for dynamically executing SQL statements,
|| needed to execute DDL commands.
*/
PROCEDURE execute_sql_statement (sql_statement IN VARCHAR2)
IS
cursor_handle INTEGER;
BEGIN
cursor_handle := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE
(cursor_handle, sql_statement, DBMS_SQL.NATIVE);
DBMS_SQL.CLOSE_CURSOR(cursor_handle);
END execute_sql_statement;
BEGIN
execute_sql_statement
('CREATE USER user1 identified by user1
default tablespace users
temporary tablespace temp');
and so on for other statements...
END;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|