Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: pl/sql

Re: pl/sql

From: Paul Druker <pdruker_at_metaway.com>
Date: 2000/05/15
Message-ID: <sI%T4.4703$f3.51122@typhoon.southeast.rr.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US