Re: Fwd: Re: (RADIATOR) Stored procedures once again

2000-07-02 Thread Mike McCauley
) Stored procedures once again Date: Fri, 30 Jun 2000 18:54:03 +0400 From: "Pavel A. Crasotin" [EMAIL PROTECTED] I've checked Oracle PLSQL reference, DBD-Oracle manual. The correct syntax to call Oracle stored procedure/function from a perl script is to wrap it in BEGIN END; block

Re: (RADIATOR) Stored procedures once again

2000-06-30 Thread Pavel A. Crasotin
I've checked Oracle PLSQL reference, DBD-Oracle manual. The correct syntax to call Oracle stored procedure/function from a perl script is to wrap it in BEGIN END; block then call prepare(), bind_param[_inout]() for IN and OUT parameters if any, than execute(). To pass returned results (it can be

Re: (RADIATOR) Stored procedures once again

2000-06-29 Thread Hugh Irvine
Hello Pavel - On Fri, 30 Jun 2000, Pavel A. Crasotin wrote: Hi all, we have stored procedure get_user_details(uname, pwd, check, reply) in Oracle8i which accepts username and returns password, check and reply items. Procedure works fine in the test Perl script. Can anyone help me and