Hey, don't forget about me! This was a very timely thread. Named bind variables in perl solves a problem I'm working on today. :)
Time to go home and have a beer. Thanks all! On Fri, 2003-11-07 at 14:09, Mladen Gogala wrote: > Count me in, too. > On 11/07/2003 12:34:26 PM, STEVE OLLIG wrote: > > That's alright Rich - you aren't the only idiot here ;) > > > > -----Original Message----- > > Sent: Friday, November 07, 2003 8:55 AM > > To: Multiple recipients of list ORACLE-L > > > > > > 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). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: STEVE OLLIG > > 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). > > > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain confidential, > proprietary or legally privileged information. No confidentiality or privilege is > waived or lost by any mistransmission. If you receive this message in error, please > immediately delete it and all copies of it from your system, destroy any hard copies > of it and notify the sender. You must not, directly or indirectly, use, disclose, > distribute, print, or copy any part of this message if you are not the intended > recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to > monitor all e-mail communications through its networks. > Any views expressed in this message are those of the individual sender, except where > the message states otherwise and the sender is authorized to state them to be the > views of any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems & Computing, DBMS Virginia Tech -- "Never get angry. Never make a threat. Reason with people." -- Mario Puzo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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).
