I *knew* it had to be something silly like that! That's what I get for using cut-and-paste. :)
Thanks! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Alan Gano [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 06, 2003 3:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ORA-911 during DBD::Oracle prepare > > > Rich! > > Take the ending semi-colon off. It's not SQL, but a > end-of-statment flag to > Sqlplus, which you are not using. > > Alan. > > -----Original Message----- > Sent: Thursday, November 06, 2003 1:29 PM > To: Multiple recipients of list ORACLE-L > > > Hey all, > > I'm trying to get a simple query running in Perl 5.6.1, DBI 1.30, > DBD::Oracle 1.14, Oracle 8.1.7 on HPUX 11.0 talking to a > 9.2.0.4 RAC DB on > Linux (whew!). Here's the pertinent part of the code: > > #!/usr/bin/perl -w > > use strict; > use DBI; > use DBD::Oracle qw(:ora_types); > > my ($dbh, $sth); > > $dbh = DBI->connect("dbi:Oracle:mysid","myuser","mypass"); > > $sth = $dbh->prepare(q{ > SELECT machine, program, SYS_CONTEXT(:userenv, :ipaddress), > SYS_CONTEXT(:userenv, :osuser) > FROM v$session VS; > }); > > At this point, I get an "ORA-911: invalid character" on the > prepare. I > thought perhaps the "$" was hosing me in "v$session", so I > tried escaping it > to "v\$session" (along with the underscores and parens) and using "qq" > instead of "q", but to no avail. > > I knew I shouldn't have unsub'd from the DBI mailing list... > > Anyone? > TIA, > Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
