call procedure from another procedure

call procedure from another procedure

 

  

How do I call a procedure from another procedure?

I am following note 99136 "CAlling os commands from
pl/sql using external procedures"

My pl/sql wrapper procedure "shell" executes os
commnads.

At SQL prompt if I type in 'exec shell(date)' it
returns the sysem date. But if I try to use it from a
proceudre like:

CREATE OR REPLACE PROCEDURE proc1 IS
BEGIN
exec shell('date');
END;

it gives me compilation error:

PLS-00103: Encountered the symbol "SHELL" when
expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "SHELL" to
continue.

Any thoughts?

Thanks in advance
anandhi

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Oracle LazyDBA home page