Re: DBD::Oracle with oracle child process with parent ID of 1

2006-05-30 Thread markd
Kong, Alan wrote: Hi all, Does anyone know why the oracle child process initiated by my perl program with parent ID of 1? My system is HPUX 11.11 with PERL5.8.0, DBI1.48, DBD-Oracle-1.16, Oracle10.2.0. I have another system with HPUX11.00, PERL5.6.1, DBI1.48, DBD-Oracle-1.16, Oracle8.1.7 w

Re: Where are the selected rows stored using fetchall_arrayref

2006-05-22 Thread markd
There is nothing to be gained here by using fetchall_arrayref, and you will almost certainly have problems. You want to actually do: while ($row = $sth->fetchrow_arrayref()) { $sock->send(join($delim, @$row)); } Mark Loo, Peter # PHX wrote: > Hi, > > I was wondering if someone can tell m

Re: Bind Values Trouble

2006-05-12 Thread markd
> Let me explain better > > I'm moving an entirely column to another in the same table the variables > are the columns names: OK, that helps. > $new_foo = "new_column"; > > $old_foo = "old_column"; > > When i use this statement everything is fine: > > $dbh->do(qq{UPDATE foos SET $new_foo =

Re: Bind Values Trouble

2006-05-12 Thread markd
Gabriel S. Oliveira wrote: > Hello I'm having a trouble with a dbi statement if anyone could help me... > > I have to do an update in a table like: > > $dbh->do(qq{UPDATE foos SET $new_foo = $old_foo}); > > when i use this statement all works fine but when i use placeholders like: > > $dbh->d