omit the "exec" when calling inside a PL/SQL block

----- Original Message -----
From: "Anandhi Narayanswamy" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, May 30, 2003 11:57 PM
Subject: 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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page