PL/SQL (MOSC)

MOSC Banner

how to call a plsql script from within a plsql script

edited Aug 8, 2011 8:03AM in PL/SQL (MOSC) 8 commentsAnswered
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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center