I may be showing my age. It happened to me a couple times a long time ago. It's possible that newer versions of Perl don't do that. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. ----- Original Message ----- From: "Ronald J Kimball" <[EMAIL PROTECTED]> To: "Michael A Chase" <[EMAIL PROTECTED]> Cc: "Shaozab, Sumera" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 17, 2001 08:34 Subject: Re: How to handle duplicate information?
> On Tue, Oct 16, 2001 at 11:45:30PM -0500, Michael A Chase wrote: > > > What does $sth1 -> execute( '' ) do? Why is it being done two times, once > > > without a variable and once with a varible in the while loop? > > > > This execute() call executes the query with an empty string as an argument. > > Oracle's SQL engine treats empty strings the same as NULL. Ordinarily, I'd > > use undef instead, but in some cases trailing undefs get stripped from > > argument lists which would result in an error in this case since execute() > > knows how many parameters it needs to match the placeholders. > > I'm not familiar with any cases where trailing undefs get stripped from > argument lists. Could you give an example?
