半年多前有人提出这个需求, 当时我也没有空去处理这事, 就搁下了. 今天将程序改动了一下, 增加了退出代码, 退出代码的含义如下:

0 = Successful
1 = Cannot login to database
2 = Cannot create cursor handle
3 = Cannot prepare SQL statement
4 = Cannot execute SQL query
5 = Cannot get the metadata of the result set
6 = Cannot create output file
7 = Oracle error found when fetching rows, such as ORA-01555 etc.

    接下来验证一下, 先是不能连接数据库的情况:

bash-2.03$ ./ociuldr.bin user=anysql/anysq1@test  query=”select * from tab”
Cannot connect as anysql/anysq1@s8i.
Connection failed.  Exiting…
bash-2.03$ echo $?
1

    提供一个错误的SQL语句:

bash-2.03$ ./ociuldr.bin user=anysql/anysql@test  query=”select * from tab1″
ORA-00942: table or view does not exist
bash-2.03$ echo $?
3

    将文件放到没有权限的目录中:

bash-2.03$ ./ociuldr.bin user=anysql/anysql@test  query=”select * from tab” file=/test.txt
   15500 bytes allocated for column TNAME (1)
    4000 bytes allocated for column TABTYPE (2)
   20500 bytes allocated for column CLUSTERID (3)

ERROR — Cannot write to file : /test.txt
bash-2.03$ echo $?
6

    希望那位朋友可以看到这个贴子. 但是如果中间空间不够了, 可能还是得不到返回值的.