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