HOST is a SQL * Plus command- You cannot use it inside a BEGIN-END block.

>>> Anandhi Narayanswamy <[Email Address Removed] 05/30/03 10:13AM >>>
CREATE OR REPLACE PROCEDURE proc1 IS
str varchar2(100);
BEGIN
host(date);
END;
/

why does the above give me compilation errors? How can
I host a command in a stored procedure?

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