RE: Oracle nested selects

> Oracle has a syntax for nested selects. E.g. > > select a, cursor(select b, ) . > > In each row fetched from such a select, some of the column > values are themselves result sets. > > DBS::Oracle version 1.16 apparently does not support such > select statements. An attempt to prepa

RE: PLease remove me from the list - Going OT

Nome, Jared! There's no place like Nome! -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 12:07 PM To: James B Schmidt Cc: DBI List Subject: Re: PLease remove me from the list Click your heels twice and utter the incantion "There's no place

Re: PLease remove me from the list

Click your heels twice and utter the incantion "There's no place like home. There's no place like home." On Wed, 2005-03-09 at 13:02, James B Schmidt wrote: > > > Please remove me from the list. > > Thank you > __ > > James B. Schmidt,

Re: Oracle nested selects

Maybe an example is in order. DBD::Oracle does support inline views, nested queries, and just about any other form of SQL thatyou can pass to it. My best guess is that you need to use sql_tags ( see the docs ) to explictly state the type of the column generating the error. On Wed, 2005-03-16 at

Re: Insert help...

On Tue, 2005-03-15 at 13:24 -0600, NIPP, SCOTT V (SBCSI) wrote: > $dbh->do(qq{ > INSERT INTO AllMid_Hist VALUES (?".(",?" x 22)."))}, # > This is where I run into issues. > undef,@old,NOW()); # I am not sure how to > structure this syntax and not hav

AW: WG: what's wrong in Win32-OLE, DBD-ADO ...

Hi Steffen, if I load DBD::ADO (with use in my script) is all ok if I do this not (I think the DBI load DBD::ADO) the error is writing. If I use 'my' variables has same effect (error if I not load DBD::ADO). I need connect_cached. Mit freundlichen Grüssen Joachim Görner Informationsverarbei

Re: DBD::Oracle - closing cursors returned from PL/SQL

Michael A Chase tech wrote: On 03/16/2005 08:25 AM, Charles Jardine said: perldoc DBD::Oracle says, under "Binding Cursors": To close the cursor you (currently) need to do this: $sth3 = $dbh->prepare("BEGIN CLOSE :cursor; END;"); $sth3->bind_param_inout(":cursor", \$sth2, 0, { ora_type => O

Re: WG: what's wrong in Win32-OLE, DBD-ADO ...

joachim.goerner wrote: [...] > > Win32::OLE(0.1702): GetOleObject() Not a Win32::OLE object at > > C:/Perl/site/lib/Win32/OLE/Lite.pm line 154 during global destruction. Oh: 'global destruction'. Can't give much advise here:

WG: what's wrong in Win32-OLE, DBD-ADO, Dynaloader or ........... .. in my script

> Hi all, > > if I write: > -- Begin snip > $|++;use strict;use warnings; > #use DBD::ADO; > #*1) > use DBI; > our ($dbh,$sth); > my $DB="dbi:ADO:driver=Microsoft Access Driver

Re: (Fwd) FW: DBI connect as sysdba

Hi all, lately I digged on this. Here is my solution: 1) Standard #!/usr/local/bin/perl -T use DBI; use strict; use warnings; delete $ENV{ 'ENV' }; $ENV{ORACLE_SID}= "CAT"; $ENV{ORACLE_HOME} = "/oracle/CAT/817_64"; $ENV{NLS_LANG} = "AMERICAN_AMERICA.WE8DEC"; $ENV{ORA_NLS}