SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Starting SQLPlus via batch script

user10877062Oct 3 2012 — edited Oct 3 2012

Hey Guys,

I'm trying to execute these lines through a batch file. However, the program stops at the SQL> prompt after connecting to SQLplus and does not execute the rest of the lines, I have to then manually run them.

sqlplus user/pass@database
set linesize 4000
set pagesize 0
set feedback off

:: RUN Usage_Report_Query

set markup html on spool on
spool Usage_Report_%systemdate%.xls
@Usage_Report_Query.sql
set markup html off spool off

Any help is greatly appretiated

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2012

Added on Oct 3 2012

#export, #query, #sqlplus

2 comments

3,601 views