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
>