Hi,

I need help urgently for following issue. Pls help me to resolve this issue.

I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)

I given sqlplus command as below.

sqlplus -S testuser/testpwd@testserver file1.sql > outputfile.dat

Actually this command is creating flat file with name of outputfile.dat but the file does not contains any records.

The output file contents that generated using sqlplus as below.

Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ] where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
<start> ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
"-H" displays the SQL*Plus version banner and usage syntax
"-V" displays the SQL*Plus version banner
"-L" attempts log on just once
"-M <o>" uses HTML markup options <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode


I need the output file contains the records that is returned from SQL Query in SQL Script(file1.sql)

Pls help me to resolve this problem. it's urgent.