Re: desc: invalid sql statement
- From: listmail@xxxxxxxxxxxx (Listmail)
- Date: Tue, 27 Dec 2005 15:25:00 -0500
Thanks Ron, I found a google hit as well and I can work around this.
From: Bob Showalter [mailto:Bob_Showalter@xxxxxxxxxxxxxxx] Sent: Tuesday, May 31, 2005 2:55 PM To: Christopher L. Hood; beginners@xxxxxxxx Subject: RE: :Oracle problems christopher.l.hood@xxxxxxxxxxx wrote: > All, > > I am getting the following error while trying to use DBD::Oracle: > > DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD > ERROR: OCIStmtExecute) [for Statement "describe ALL_USERS"] at > ../oracleTest.pl line 69.
DESCRIBE is a SQL*Plus command. It is not part of the Oracle SQL language. You need to either query the data dictionary views directly, or use the statement handle attributes like NAME, PRECISION, TYPE, etc. to get this information.
Reidy, Ron wrote:
'desc' is a Plus command in Oracle. It is not valid SQL.
-- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message-----
From: listmail [mailto:listmail@xxxxxxxxxxxx] Sent: Tuesday, December 27, 2005 12:36 PM
To: dbi-users@xxxxxxxx
Subject: desc: invalid sql statement
I believe a describe statement is Oracle DDL, but I still failed for both of the ways that I know of to execute sql. There must be something
that I am not considering.
#!/usr/local/bin/perl #script to demonstate execution failure use strict; use warnings;
use DBI; use DBD::Oracle;
my $username=''; my $password=''; my $dbsid=''; my $cont;
eval {
$cont = DBI->connect('dbi:Oracle:' . lc($dbsid), $username, $password,
{
RaiseError => 1,
AutoCommit => 0,
ora_session_mode => 0
}
);
};
die "problem" if ($@);
my $sth;
#1 eval { $sth = $cont->prepare("desc user_tables"); };
if ($@) {
print "$DBI::errstr";
#exit;
} else {
eval {
$sth->execute;
};
if ($@) {
print "$DBI::errstr";
#exit;
}
}
#2 eval { $cont->do("desc user_tables"); };
if ($@) { print "$DBI::errstr"; #exit; }
# Windows XP # DBI 1.48 # DBD-Oracle 1.16 # ActivePerl 5.8.7 build 813
DBD::Oracle::st execute failed: ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "desc user_tables"] at C:\DATA\SESS_KILL\DBD-DBI_testing.pl line 37.
ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) <--print
output DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD
ERROR: OCIStmtExecute) [for Statement "desc user_tables"] at C:\DATA\SESS_KILL\DBD-DBI_testing.pl line 48.
ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute) <--print
output Issuing rollback() for database handle being DESTROY'd without
explicit disconnect().
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
.
- References:
- RE: desc: invalid sql statement
- From: Ron Reidy
- RE: desc: invalid sql statement
- Prev by Date: RE: desc: invalid sql statement
- Next by Date: RE: DBD-Sybase 1.07, FreeTDS 0.63, HPUX 11.11: Build problem (maketest)
- Previous by thread: RE: desc: invalid sql statement
- Next by thread: desc: invalid sql statement, answered
- Index(es):
Relevant Pages
|
|
