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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > 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]; > > } > > [EMAIL PROTECTED]; > > > > > > Alan. -- 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).
