Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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 CDT
![]() |
![]() |