how to call a plsql script from within a plsql script
oracle 9i/10g/11g
I want to call a sql script within a sql script.
I have a script that checks the temporary tbs. Depends on the name of the temp tbs, I will call a set of script to create new temp tbs, with different names.
ie, if the current temp tbs is pstemp, I want to create a new temp tbs named pstemp1.
script 1:
===================
declare
...
begin
...
if this THEN
@sc_pstemp;
else
@sc_pstemp_1;
end;
/
exit;
===================
script 2:
===================
CREATE TEMPORARY TABLESPACE CWTEMP TEMPFILE
'O:\PSTEMP.ORA' SIZE 150M REUSE AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 30M;
I want to call a sql script within a sql script.
I have a script that checks the temporary tbs. Depends on the name of the temp tbs, I will call a set of script to create new temp tbs, with different names.
ie, if the current temp tbs is pstemp, I want to create a new temp tbs named pstemp1.
script 1:
===================
declare
...
begin
...
if this THEN
@sc_pstemp;
else
@sc_pstemp_1;
end;
/
exit;
===================
script 2:
===================
CREATE TEMPORARY TABLESPACE CWTEMP TEMPFILE
'O:\PSTEMP.ORA' SIZE 150M REUSE AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 30M;
0