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