Please reply to the list.  I don't always check my mail every day and others
often have ideas to share.

When you execute the script from the command line, you don't even get the
message from before execute()?  You might want to add print statements
before connect() and prepare() to make sure the script actually started.

You might also add '$| = 1;' to the script to make sure the "hasta aqui\n"
message isn't trapped in a buffer.  That shouldn't be necessary when running
from the command line unless you are redirecting the output, but it won't
hurt for small amounts of output.
--
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 11:10
Subject: RE: Problem with stored procedures


That looks good under SQL*Plus but with DBI isn�t the same that look like
this:

[mmacias@intranet detalles]$
[mmacias@intranet detalles]$
[mmacias@intranet detalles]$
[mmacias@intranet detalles]$ perl prueba.plx
The cursor stays there, under the next line ..... there isn�t error
notifications.....  prueba.plx   is the CGI on another server called
intranet


Hern�n Moreno Murillo.
Ingeniero de  Desarrollo 3T.  PORTA.
Oficina:  2517 000 ext. 4146    Celular: 09 9613 572
www.porta.net

> -----Mensaje original-----
> De: Michael A Chase [SMTP:[EMAIL PROTECTED]]
> Enviado el: Viernes 12 de Octubre de 2001 10:14 AM
> Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Asunto: Re:  Problem with stored procedures
>
> 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