(RADIATOR) using stored procedures...

[Mariano Absatz]

El 24 Sep 2001, a las 16:37, Mariano Absatz escribió:

> 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>

Sorry, I should've said, instead of:

FailureQuery INSERT INTO AUTH_LOG \
    (TIME_STAMP,USERNAME,PASSWORD,REASON) \
  VALUES \
    %t,'%n','%P','%1')

use this:
FailureQuery BEGIN SP_INSERT_AUTH_LOG (:1,:2,:3,:4); 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
----------------------------------------------------------
We are born naked, wet and hungry. Then things get worse. 

===
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.