Re: pl/sql

Larry,

Please see Unix example below:

#!/bin/ksh
# Go into sqlplus and execute the command sqlplus -s ${USERID_PWD} <<EOF
set serveroutput on size 1000000
spool /tmp/tmp.lst
<... sqlplus commands...>
BEGIN
   <... pl/sql stuff ...>
   dbms_output.put_line('Command:');
   <... pl/sql stuff ...>
END;
/
exit
EOF
print "Completed at $(date)"

Thanks,
Paul

"Larry Pettit" <larry.pettit_at_ps.net> wrote in message news:jFZT4.572$Cq4.22898_at_news.uswest.net...
> How can you execute a PL/SQL program from a batch file in Unix or NT?
>
>
Received on Mon May 15 2000 - 00:00:00 CEST