RE: ORA-911 during DBD::Oracle prepare

The thing about it is that I distinctly remember complaining in a comment in one of my Perl/DBI progs about having to use positional binds. And now I can't find it. Oh well. Live and learn and hope no one else comes across that bit of code to see what an idiot I am.

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

Disclaimer: I'm an idiot. The difference between me and other idiots is that I know I'm an idiot.

> -----Original Message-----
> From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
> Sent: Thursday, November 06, 2003 4:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ORA-911 during DBD::Oracle prepare
>
>
> It works! It works, it works!
> On 11/06/2003 05:14:24 PM, Alan Gano wrote:
> >
> > DBI is able to use named binds
> >
> > e.g.,
> >
> > my $cursor=$$self{conn}->prepare(q{
> > select column_name from
> > dba_cons_columns
> > where
> > (owner,constraint_name) = (
> > select owner, constraint_name
> > from dba_constraints
> > where
> > owner = :table_owner AND
> > table_name = :table_name AND
> > constraint_type = 'P'
> > )
> > });
> > $cursor->bind_param(":table_owner",uc($owner));
> > $cursor->bind_param(":table_name",uc($table));
> > $cursor->execute();
> >
> > $$self{pk_columns}=[];
> > my @columns;
> > while(my $row=$cursor->fetchrow_arrayref())
> > {
> > push @columns,$$row[0];
> > }
> > $$self{pk_columns}=\@columns;
> >
> >
> > Alan.

-- 
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).