Re: Howto:Perl connection to Oracle

On Feb 28, 7:52 am, Bill <edi...@xxxxxxxxxxxx> wrote:
Anything out there that's well documented and half way easy to learn,
maybe even with some examples?

thanks in advance-
Bill

the DBI is not that hard to use. Getting the connection going is the
first step and requires that you have the appropriate Oracle drivers
on the machine hosting the code, then getting the right settings to
plug into the DSN. You'll need the database name, the host name, the
port you're connecting to, the user ID and password, and to decide
whether you're going to let the DBI handle your error handling,
reporting and whether it should commit automatically.

Then, based on your application's needs, you'll want to get familiar
with do(), prepare(), execute() and selectrow_array() routines.

The DBI docs are pretty good and are mirrored in the "Programming the
Perl DBI" book from O'Reilly. I prefer the online docs at
http://search.cpan.org/~timb/DBI/DBI.pm though I regularly make a mess
of my monitor's screen highlighting sections and writing notes. :-)

.

Relevant Pages

  • Re: RDB limitations: from Jimmy Gavan
    ... Your DBI QUESTION: ... Bearing in mind no compiler to reference or even test my thoughts, ... The unique Id is used as a DB connection ... move SQLSTATE to MOST-SQLSTATE ...
    (comp.lang.cobol)
  • RE: :Oracle - with ora10g oci.dll
    ... I agree it's not a DBD or DBI error. ... your connection descriptor seems suspect: ... how to get to our nameservers. ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)
  • Re: Mysql::Simple?
    ... GetOptions passthrough to interpret standard mysql options, ... it work with standard DBI environment variables, ... This way I find it easy to set up and wangle connection details. ... > Fetches the next row of data and returns a reference to an array holding the ...
    (comp.lang.perl.modules)
  • Re: DBI v2 - The Plan and How You Can Help
    ... $sth1.prepare; # always with connection, even if DBD doesn't use it $sth1.execute; # always with connection ... method the arguments you would have given to prepare, and you invoke prepareon the result with no arguments; each DBD would decide for itself how the work is divided between compileand preparewith the limitation that compileis not allowed to access the database; ideally the DBD would place as much work there as is possible, which would vary between Oracle/Pg/etc. ... designed to effectively support wrapper modules, the wrapper modules would also be altered from their current DBI-1-geared designs to accomodate DBI-2. ... module just because a new driver came into existence whose name has not yet been hard-coded into DBI. ...
    (perl.dbi.users)
  • Re: DBD::DB2 question need an example
    ... I've installed the latest Active state Perl, the latest DBI and DBD::DB2 ... but I can't make the connection work...... ... connecting to the database ...
    (perl.dbi.users)