(RADIATOR) Oracle stored procedures

[Pavel A Crasotin]

Hi Viraj,

If you want to get more complicated results returned by stored
procedures try to use AuthBy PLSQL clause. AuthPLSQL.pm is in goodies
dir.

VA> Hello,

VA>         We were having some difficulty using Oracle stored procedures with
VA> Radiator (and DBI in general). Maybe some of this is helpful to others,
VA> but we found that we couldn't use 'exec' in the DBI query. It seems 'exec'
VA> may be something specific to Sqlplus, but I'm not sure. Anyhow, we wanted
VA> our AddQuery for SessionDatabase SQL to call a stored procedure. The only
VA> thing that worked was similar to the following:

VA> AddQuery BEGIN my_procedure('%n', ...); END;

VA> We had also used a stored procedure in an AuthBy SQL that took the
VA> username as argument and returned the password:

VA> AuthSelect select validate_password(%0) from dual
VA> AuthColumnDef 0, User-Password, check

VA> dual is an Oracle builtin junk table that always returns the row you
VA> selected for.

VA> Hope this helps, and if anyone has some other suggestions I'd be
VA> interested.

VA> Viraj.

VA> ===
VA> Archive at http://www.open.com.au/archives/radiator/
VA> Announcements on radiator-announce at open.com.au
VA> To unsubscribe, email 'majordomo at open.com.au' with
VA> 'unsubscribe radiator' in the body of the message.


With respect,
Pavel A Crasotin
____________________________________
OJSC SeverTransCom
40/13 Sobinova, Yaroslavl, 150000, Russia
Tel/Fax: +7 (0852) 47-71-70, 47-69-49
         +7 (0852) 72-17-28, 72-17-38

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