Re: Oracle functions through DBI?

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 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 me it would be much more simple and
efficient than the same old way!!

thanks
Riccardo




--
Alexander Foken
mailto:alexander@xxxxxxxx http://www.foken.de/alexander/

.

Relevant Pages

  • RE: oracle win2k ORA-1222 problems
    ... AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com. ... Oracle is listed as "failed" if I recall correctly. ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • RE: DBI problem
    ... I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from ... DBD 1.16 and DBI 1.48. ... Did you install DBD::Oracle? ...
    (perl.dbi.users)
  • RE: (Fwd) DBD:: Oracle Problems
    ... The error is being thrown inside the pl/sql procedure itself not the DBI! ... Subject: DBD:: Oracle Problems ... are receiving the following error when we execute any stored procedures. ... This email has been scanned by the MessageLabs Email Security System. ...
    (perl.dbi.users)
  • Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin
    ... If not: you could reinstall DBI and DBD::Oracle and make sure that your Oracle environment is set correctly. ... If you have multiple Oracle installations: set your $ENVusing the ORACLE_HOME with which you compiled your DBD::Oracle. ... If you have multiple perl installations (with DBI, DBD::Oracle) you may have to set the correct path to perl (first line of your script). ...
    (perl.dbi.users)
  • RE: Unix: Oracle User Identified Externally
    ... Subject: Unix: Oracle User Identified Externally ... use DBI; ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)