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