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: 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 John Scoles
print @$page_data; print ""; print $desc_out; where my insert_comment stored Procedure starts like CREATE procedure insert_comment(in_ID in NUMBER, in_log in out clob, out_log in out clob ) - Original Message - From: "Riccardo Bonuccelli" <[EMAIL PROTECTED]&

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? for