Try "select * from device"
-----Original Message-----
From: David N Murray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 2:28 PM
To: Ford, Andy
Cc: '[EMAIL PROTECTED]'
Subject: Re: "missing left parenthesis" problem running DBD::Oracle
SQL> select * from table device;
select * from table device
*
ERROR at line 1:
ORA-00906: missing left parenthesis
SQL>
On Dec 17, Ford, Andy scribed:
> I'm getting an error running DBD::Oracle:
>
> DBD::Oracle::db do failed: ORA-00906: missing left parenthesis (DBD ERROR:
> OCIStmtExecute/Describe) at ./trace.pl line 13.
>
> The environment is perl 5.6.1 on Solaris 8 with DBI 1.32 and DBD-Oracle
> 1.12.
>
> The script that produces the above error is just:
>
> #!/opt/perl5/bin/perl -w
> use strict;
> use diagnostics;
> use DBI;
> use DBD::Oracle;
> my ($dbname,$user,$passwd) = qw(KONFIG *** ****);
> my $dev = $ARGV[0];
> BEGIN {
> $ENV{ORACLE_HOME} = '/opt/oracle/product/8.1.6';
> $ENV{ORACLE_SID} = 'KONFIG';
> }
> my $dbh = DBI->connect("dbi:Oracle:KONFIG", $user, $passwd);
> $dbh->do("SELECT uui FROM table device WHERE name = $dev");
> $dbh->disconnect;
>
> So it looks like I'm connecting OK, but the "do" fails.
>
> Thanks
>
> Andy Ford
> A.G. Edwards & Sons, Inc.
> [EMAIL PROTECTED]
> 314-955-6647
>
>
>
> HOw bout a trace:
> DBI 1.32-nothread dispatch trace level set to 5
> -> DBI->connect(dbi:Oracle:KONFIG, konfigmgr, ****)
> -> DBI->install_driver(Oracle) for solaris perl=5.006001 pid=29335
> ruid=13013 euid=13013
> install_driver: DBD::Oracle version 1.12 loaded from
> /opt/perlmod/lib/site_perl/5.6.1/sun4-solaris/DBD/Oracle.pm
> New DBI::dr (for DBD::Oracle::dr, parent=, id=)
> dbih_setup_handle(DBI::dr=HASH(0x2d46b4)=>DBI::dr=HASH(0x3184c8),
> DBD::Oracle::dr, 0, Null!)
> dbih_make_com(Null!, DBD::Oracle::dr, 88) thr#0
> dbih_setup_attrib(DBI::dr=HASH(0x3184c8), Err, Null!) SCALAR(0x29b798)
> (already defined)
> dbih_setup_attrib(DBI::dr=HASH(0x3184c8), State, Null!)
SCALAR(0x2d64e0)
> (already defined)
> dbih_setup_attrib(DBI::dr=HASH(0x3184c8), Errstr, Null!)
> SCALAR(0x29b774) (already defined)
> dbih_setup_attrib(DBI::dr=HASH(0x3184c8), Debug, Null!) 0 (already
> defined)
> dbih_setup_attrib(DBI::dr=HASH(0x3184c8), FetchHashKeyName, Null!)
> 'NAME' (already defined)
> <- install_driver= DBI::dr=HASH(0x2d46b4)
> -> connect for DBD::Oracle::dr (DBI::dr=HASH(0x2d46b4)~0x3184c8
'KONFIG'
> 'konfigmgr' **** HASH(0x2b5cc8))
> New DBI::db (for DBD::Oracle::db, parent=DBI::dr=HASH(0x3184c8), id=)
> dbih_setup_handle(DBI::db=HASH(0x31848c)=>DBI::db=HASH(0x3177ec),
> DBD::Oracle::db, 2d1bf4, Null!)
> dbih_make_com(DBI::dr=HASH(0x3184c8), DBD::Oracle::db, 116) thr#0
> dbih_setup_attrib(DBI::db=HASH(0x3177ec), Err, DBI::dr=HASH(0x3184c8))
> SCALAR(0x29b798) (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x3177ec), State,
DBI::dr=HASH(0x3184c8))
> SCALAR(0x2d64e0) (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x3177ec), Errstr,
> DBI::dr=HASH(0x3184c8)) SCALAR(0x29b774) (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x3177ec), Debug,
DBI::dr=HASH(0x3184c8))
> 0 (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x3177ec), FetchHashKeyName,
> DBI::dr=HASH(0x3184c8)) 'NAME' (already defined)
> dbih_setup_attrib(DBI::db=HASH(0x3177ec), HandleError,
> DBI::dr=HASH(0x3184c8)) undef (not defined)
> <- connect= DBI::db=HASH(0x31848c) at
> /opt/perlmod/lib/site_perl/5.6.1/sun4-solaris/DBI.pm line 513 via
./trace.pl
> line 13
> -> STORE for DBD::Oracle::db (DBI::db=HASH(0x3177ec)~INNER
'PrintError'
> 1)
> STORE DBI::db=HASH(0x3177ec) 'PrintError' => 1
> <- STORE= 1 at /opt/perlmod/lib/site_perl/5.6.1/sun4-solaris/DBI.pm
line
> 555 via ./trace.pl line 13
> -> STORE for DBD::Oracle::db (DBI::db=HASH(0x3177ec)~INNER
'AutoCommit'
> 1)
> <- STORE= 1 at /opt/perlmod/lib/site_perl/5.6.1/sun4-solaris/DBI.pm
line
> 555 via ./trace.pl line 13
> <- connect= DBI::db=HASH(0x31848c)
> -> do in DBD::_::db for DBD::Oracle::db
(DBI::db=HASH(0x31848c)~0x3177ec
> 'SELECT uui FROM table device WHERE name = 245245')
> 1 -> prepare for DBD::Oracle::db (DBI::db=HASH(0x3177ec)~INNER 'SELECT
uui
> FROM table device WHERE name = 245245' undef)
> New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x3177ec), id=)
> dbih_setup_handle(DBI::st=HASH(0x3184bc)=>DBI::st=HASH(0x318444),
> DBD::Oracle::st, 3184f8, Null!)
> dbih_make_com(DBI::db=HASH(0x3177ec), DBD::Oracle::st, 208) thr#0
> dbih_setup_attrib(DBI::st=HASH(0x318444), Err, DBI::db=HASH(0x3177ec))
> SCALAR(0x29b798) (already defined)
> dbih_setup_attrib(DBI::st=HASH(0x318444), State,
DBI::db=HASH(0x3177ec))
> SCALAR(0x2d64e0) (already defined)
> dbih_setup_attrib(DBI::st=HASH(0x318444), Errstr,
> DBI::db=HASH(0x3177ec)) SCALAR(0x29b774) (already defined)
> dbih_setup_attrib(DBI::st=HASH(0x318444), Debug,
DBI::db=HASH(0x3177ec))
> 0 (already defined)
> dbih_setup_attrib(DBI::st=HASH(0x318444), FetchHashKeyName,
> DBI::db=HASH(0x3177ec)) 'NAME' (already defined)
> dbih_setup_attrib(DBI::st=HASH(0x318444), HandleError,
> DBI::db=HASH(0x3177ec)) undef (not defined)
> dbd_st_prepare'd sql SELECT
> dbd_describe SELECT (EXPLICIT, lb 80)...
> OCIErrorGet after OCIStmtExecute/Describe (er1:ok): -1, 906:
ORA-00906:
> missing left parenthesis
>
> !! ERROR: 906 'ORA-00906: missing left parenthesis (DBD ERROR:
> OCIStmtExecute/Describe)'
> 1 <- prepare= undef at
> /opt/perlmod/lib/site_perl/5.6.1/sun4-solaris/DBI.pm line 1220 via
> ./trace.pl line 14
> !! ERROR: 906 'ORA-00906: missing left parenthesis (DBD ERROR:
> OCIStmtExecute/Describe)'
> <- do= undef at ./trace.pl line 14
> DBD::Oracle::db do failed: ORA-00906: missing left parenthesis (DBD ERROR:
> OCIStmtExecute/Describe) at ./trace.pl line 14.
> <> DESTROY ignored for outer handle DBI::st=HASH(0x3184bc) (inner
> DBI::st=HASH(0x318444))
> -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x318444)~INNER)
> <- DESTROY= undef at ./trace.pl line 15
> dbih_clearcom 0x3184bc (com 0x345518, type 3) done.
>
> -> disconnect for DBD::Oracle::db (DBI::db=HASH(0x31848c)~0x3177ec)
> <- disconnect= 1 at ./trace.pl line 15
> <> DESTROY ignored for outer handle DBI::db=HASH(0x31848c) (inner
> DBI::db=HASH(0x3177ec))
> -> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x3177ec)~INNER)
> <- DESTROY= undef
> dbih_clearcom 0x31848c (com 0x319da8, type 2) done.
>
> -- DBI::END
> -> disconnect_all for DBD::Oracle::dr
(DBI::dr=HASH(0x2d46b4)~0x3184c8)
> <- disconnect_all= '' at
> /opt/perlmod/lib/site_perl/5.6.1/sun4-solaris/DBI.pm line 575 via
./trace.pl
> line 0
> dbih_clearcom 0x2d46b4 (com 0x319d30, type 1) done.
>
> <> DESTROY for DBI::dr=HASH(0x2d46b4) ignored (inner handle gone)
>
>
>
>
****************************************************************************
*******
> WARNING: All e-mail sent to and from this address will be received or
> otherwise recorded by the A.G. Edwards corporate e-mail system and is
> subject to archival, monitoring or review by, and/or disclosure to,
> someone other than the recipient.
>
****************************************************************************
********
>
� 2002 OpenLink Financial
Copyright in this message and any attachments remains with us. It is
confidential and may be legally privileged. If this message is not
intended for you it must not be read, copied or used by you or
disclosed to anyone else. Please advise the sender immediately if
you have received this message in error.
Although this message and any attachments are believed to be free of
any virus or other defect that might affect any computer system into
which it is received and opened, it is the responsibility of the
recipient to ensure that it is virus free and no responsibility
is accepted by Open Link Financial, Inc. for any loss or damage in any
way arising from its use.
