Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-911 during DBD::Oracle prepare
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
Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com 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: ListGuru_at_fatcity.com (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).Received on Thu Nov 06 2003 - 15:29:25 CST
![]() |
![]() |