Hi there...
I am wondering... is there any way to replace queries in the config file with
calls to stored procedures _with_detached_parameters_?
That is, I want to say, for instance, instead of:
FailureQuery INSERT INTO AUTH_LOG \
(TIME_STAMP,USERNAME,PASSWORD,REASON) \
VALUES \
%t,'%n','%P','%1')
FailureQuery BEGIN SP_INSERT_AUTH_LOG (:1,:2); END \
<PARAMLIST> %t,'%n','%P','%1' </PARAMLIST>
I don't know what syntax to use, but the parameters should be a Perl array
passed (by reference) to prepare() as the second argument.
Maybe even use prepare_cached()?
TIA
--
Mariano Absatz
El Baby
----------------------------------------------------------
If at first you don't succeed, call it version 1.0
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.