(RADIATOR) using stored procedures...

[Mariano Absatz]

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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.