[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] sql-status return -1 in sqr vSQR V6.1.4

Many thanks, got the same. I opened a case with PS to find out what they did

Peter 

-----Original Message-----
From: sqr-users-bounces+pdaalder=2coolboarders.com@sqrug.org
[mailto:sqr-users-bounces+pdaalder=2coolboarders.com@sqrug.org] On Behalf Of
George Jansen
Sent: 10 March 2005 13:43
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] sql-status return -1 in sqr vSQR V6.1.4

As far as the error-handling in Oracle, your machine likely has
$ORACLE_HOME/bin/oratclsh, which is used by Oracle Intelligent Agent to run
Oracle Enterprise Manager jobs

Try a script such as:

!/usr/bin/env oratclsh
set lda [oralogon scott/tiger@mydb]
set crs [oraopen $lda]
orasql $crs "SELECT 1 FROM 123"
puts $oramsg(rc)

in both cases, 8.1.7, and 9.2.0, I get plain old "903", invalid table name;
I don't get -903 in either. It seems to me that this is an SQRism.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users