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.
