Create Temporary Table in ORACLE Stored Procedure.
Posted on 2006-11-27
Queation :- Create Temporary Table in ORACLE Stored Procedure.
I want to create Temporary Table, when SP is executed and then populate some data in it.
My Sample code is displaying error :- PL/SQL: ORA-00942: table or view does not exist.
Sample Code :-
CREATE OR REPLACE PROCEDURE Temptabletest
EXECUTE IMMEDIATE 'CREATE global TEMPORARY TABLE G_Temp_1
ON COMMIT DELETE ROWS';
INSERT INTO G_Temp_1 VALUES (100);