Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id hA71OCt08927 for ; Thu, 6 Nov 2003 19:24:12 -0600 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id hA71OAc08922 for ; Thu, 6 Nov 2003 19:24:11 -0600 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id hA6MU1dd012845 for ; Thu, 6 Nov 2003 14:31:41 -0800 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id hA6LjPJ9019966 for oracle-l@orafaq.net; Thu, 6 Nov 2003 13:45:27 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D5DC3; Thu, 06 Nov 2003 13:49:25 -0800 Message-ID: Date: Thu, 06 Nov 2003 13:49:25 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Alan Gano Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Alan Gano Subject: RE: ORA-911 during DBD::Oracle prepare Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 Rich Jesse System/Database Administrator rjesse@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@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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alan Gano INET: Alan.Gano@Banfield.net 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@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).