Re: Announcement/Request for Comments: DBIx::Call

From: Dean Arnold (darnold_at_presicient.com)
Date: 11/26/04

  • Next message: Michael A Chase tech: "Re: DBI use failure with DBI/DBD::Oracle on AIX 5.2" 
    Date: Thu, 25 Nov 2004 16:57:03 -0800
To: Thilo Planz <thilo.planz@gaiax.co.jp>

    Thilo Planz wrote:
    >
    >> I've actually been hacking something
    >> akin to this for SQL::Preproc
    >
    >
    > SQL::Preproc ?
    > Can I get that somewhere?

    Sorry, not ready yet, but theres a prelim
    bit of POD at www.presicient.com/sqlpp.

    >
    >> Also, is there any support for using e.g.,
    >> - SQL qualifiers on parameters,
    >
    >
    > hmm. dont know what that is...
    >

    In various SQL syntaxes (including ANSI, I believe),
    placeholders and literals occasionally need "qualification",
    e.g., intervals and timestamps. Also, sometimes string
    values need qualification for case-sensitivity and/or character
    set to be applied.

    >> - SQL literals,
    >
    >
    > No.
    >
    >> - native SQL functions,
    >
    >
    > Not specifically.
    > But in Oracle you can call a lot of SQL functions as if they were stored
    > procedures, so I expect the following to work:
    >
    > use DBIx::ProcedureCall qw ( greatest );
    > print greatest ($dbh, 1, 2, 3, 4, 5);
    >
    > Thanks for that hint, by the way, makes writing a test suite easier.
    >
    >
    >> - etc.
    >
    >
    > The module wants to provide an extremely simple interface to the most
    > common forms of stored procedures.
    > It will not be able to handle everything.
    > That is not the goal, if it can eliminate 90% of hand-written SQL and
    > bind calls, I am happy.
    >
    > What I plan to support in future versions are:
    > - OUT and INOUT params
    > - cursors
    >
    >
    > Thilo
    >

    Okay. Still a useful/nifty module, IMO.

    Dean Arnold
    Presicient Corp.

  • Next message: Michael A Chase tech: "Re: DBI use failure with DBI/DBD::Oracle on AIX 5.2"