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