Re: DBD::Sybase question

2006-04-26 Thread michael . peppler
Hi, Yes, I know about that script - but you should still be careful when you use a binary built with a 12.5.1 client installation against a 15.0 run-time. It would probably be better to rebuild. Michael Extranet [EMAIL PROTECTED] - 25/04/2006 17:13 To: Michael PEPPLER cc:

Oracle functions through DBI?

2006-04-26 Thread Riccardo Bonuccelli
Hello, I was wondering (and found nothing bout that on the web), can I use DBI to execute some oracle DB functions? Here's my case: I have a (oracle) function that returns a new free ROW ID randomly and I have to manage that RI from a perl script. Can I use DBI to submit the request to oracle?

MySql function

2006-04-26 Thread Akpome Akpoguma
Hi Everyone, i did the following $dbh-prepare(UPDATE contentTable SET filename = '$dbfile date_modefied = 'CURRENT_DATE()' time_modefied = 'CURRENT_TIME() WHERE ext = '$ext' ) and the value of the current date and current time were not updated on the table. It seems perl

RE: MySql function

2006-04-26 Thread Ronald J Kimball
Akpome Akpoguma [mailto:[EMAIL PROTECTED] wrote: Hi Everyone, i did the following $dbh-prepare(UPDATE contentTable SET filename = '$dbfile date_modefied = 'CURRENT_DATE()' time_modefied = 'CURRENT_TIME() WHERE ext = '$ext' ) and the value of the current date and current time

Re: Oracle functions through DBI?

2006-04-26 Thread John Scoles
Yes one can quite simply at least for a Stored procedure as for a function you may have to wrap it in some SQL first. my $db=; my $db = DBI-connect(); my $desc = 'Comments from user '; my $desc_out =; my $sql=begin insert_comment(:p_id ,:p_desc,:p_desc_out); end;; my $c=$db-prepare($sql)

Re: Oracle functions through DBI?

2006-04-26 Thread Alexander Foken
You want to read http://search.cpan.org/~pythian/DBD-Oracle-1.17/Oracle.pm#PL/SQL_Examples Alexander Riccardo Bonuccelli wrote: Hello, I was wondering (and found nothing bout that on the web), can I use DBI to execute some oracle DB functions? Here's my case: I have a (oracle) function that

RE: Oracle functions through DBI?

2006-04-26 Thread Reidy, Ron
http://search.cpan.org/~pythian/DBD-Oracle-1.17/Oracle.pm#Other_Data_Typ es -Original Message- From: Riccardo Bonuccelli [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 8:46 AM To: dbi-users@perl.org Subject: Oracle functions through DBI? Hello, I was wondering (and found

Re: how to set a DEFAULT value !!

2006-04-26 Thread David Nicol
On 4/24/06, Greg Sabino Mullane [EMAIL PROTECTED] wrote: I've proposed adding something simlilar to DBI itself, but I don't recall getting any feedback on it. Presumably once in place DBIx::Class will someday support it. DBI is complex enough, and AIUI the DBI philosophy opposes adding

Re: last insert id

2006-04-26 Thread Daniel Kasak
Ron Savage wrote: On Sun, 16 Apr 2006 22:15:22 +1000, Daniel Kasak wrote: Hi Daniel DBI: V 1.47 DBD::mysql: V 3.002 There are critical bugs in the $dbh-column_info() method in DBD::mysql-3.x that prevent us from upgrading :( I've tried a line identical to your: $id = $self - dbh() -

Re: how to set a DEFAULT value !!

2006-04-26 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 DBI is complex enough, and AIUI the DBI philosophy opposes adding features to the core that will cause implementation headaches for driver authors. The standard perl idiom for default values is You misunderstand. The DEFAULT is on the database

DBD::Oracle ppd

2006-04-26 Thread Jeffrey Seger
Any other repositories anyone knows of where I can download this? ftp.esoftmatic.com and ppm.activestate.com have both been unreachable all day. Google has been uncharacteristically unhelpful. tia, jeff --

Re: how to set a DEFAULT value !!

2006-04-26 Thread Ron Savage
On Thu, 27 Apr 2006 03:45:22 -, Greg Sabino Mullane wrote: Hi Greg You misunderstand. The DEFAULT is on the database side, not the Just curious. Which database server is this? And, can you omit the name of the column you want defaulted, and does this server then insert the default value?

Re: DBD::Oracle ppd

2006-04-26 Thread Ron Savage
On Wed, 26 Apr 2006 23:55:43 -0400, Jeffrey Seger wrote: Hi Jeffrey Any other repositories anyone knows of where I can download this? I tried a few sites, but can't see Oracle stuff. As a last resort, try http://dada.perl.it/#ppm and go round the PerlRing site by site :-(. -- Ron Savage

Re: DBD::Oracle ppd

2006-04-26 Thread Jeffrey Seger
Any other repositories anyone knows of where I can download this? I tried a few sites, but can't see Oracle stuff. As a last resort, try http://dada.perl.it/#ppm and go round the PerlRing site by site :-(. Thanks Ron. I tried the search the ring tool on the perlring and no joy. Maybe one

Re: how to set a DEFAULT value !!

2006-04-26 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 NotDashEscaped: You need GnuPG to verify this message Which database server is this? This is definitely the behavior of MySQL, PostgreSQL, and Oracle, and I'm pretty sure most others follow it as well. And, can you omit the name of the column

Re: how to set a DEFAULT value !!

2006-04-26 Thread Ron Savage
On Thu, 27 Apr 2006 04:37:20 -, Greg Sabino Mullane wrote: Hi Greg It's late here, so hope that made sense. :) Yep. It means just that much more I don't know... -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html