I haven't used packages or stored functions from DBI very often, but I
haven't seen any problems when I have.

What happens if you run the following under SQL*Plus with the same
userid/password@instance?

VARIABLE whoami VARCHAR2(30)
BEGIN
   :whoami := plsql_example.func_np;
END;
/
PRINT whoami

--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 12, 2001 07:45
Subject: Problem with stored procedures



> I have a problem when i was trying to access  data base with  the
> DBD::Oracle, my the problem is:
> Using any stored procedure with parameters the script remains paralyzed
> (zombie) I even used of such examples of the documentation but the result
> was negative.
>
> Of course this stored procedure exists in the data base
> (plsql_example.func_np)
>
> **************************************************************************
> ******************************
> #!/usr/bin/perl
>
>      use DBI;
> use DBD::Oracle qw(ORA_VARCHAR2);
>      use strict;
> my($db, $sth, $ret_val);
>
>    $ENV{ORACLE_HOME}  = "/u1/oracle/product/8.0.5";
>    $db = DBI->connect("dbi:Oracle:host=my_ip.com;sid=gyte", "VMA",
> "veritus")
>         or die "Unable to connect: $DBI::errstr";
>  $db->{RaiseError} = 1;
>
> my $whoami="";
> my $sql = qq(
> BEGIN
>     :whoami := plsql_example.func_np;
> END;
> );
> $sth = $db->prepare($sql);
> $sth->bind_param_inout( ":whoami", \$whoami, 30,{ora_type => ORA_VARCHAR2}
> );
> print "hasta aqui\n";
> $sth->execute;
> print "esto no funciona\n";
> $db->disconnect;
> **************************************************************************
> ******************************
> Only the first message is printed (hasta aqui)
> the second isn�t.
> **************************************************************************
> ******************************
> OS = Linux Mandrake (with perl 5)
> DB = Oracle 8i
> **************************************************************************
> ******************************
> Also this description is important,I can do all kind of selects,
> insert,updates but if i use parameters like used in stored procedures then
> it doesn�t work.
>
>
>
> Hern�n Moreno Murillo.
> Ingeniero de  Desarrollo 3T.  PORTA.
> Oficina:  2517 000 ext. 4146    Celular: 09 9613 572
> www.porta.net
>


Reply via email to