sub valida_user
{

use DBI;
use DBD::Oracle qw(ORA_VARCHAR2);
my($db, $sth);

   $ENV{ORACLE_HOME}  = "/u1/oracle/product/8.0.5";
   $db = DBI->connect("dbi:Oracle:host=my_ip;sid=fty", "hmo", "hmo")
        or die "Unable to connect: $DBI::errstr";

  $db->{RaiseError} = 1;


 my $user=$_[0];
 my $password=$_[1];

 my $query = "select count(*) from sm_usuarios_dat where IDEN_USUA = :user
and PASS_USUA= :password";
 my $conteo=0;
 $sth = $db->prepare($query);
 $sth->bind_param(":user",$user,20);
 $sth->bind_param(":password",$password,20);
 $sth->execute() or return undef;

 $conteo= $sth->fetchrow_array;
 $db->disconnect;     

 return $conteo;
}

****************************************************************************
***********************
this is showed:

DBD::Oracle::st execute failed: ORA-00904: invalid column name (DBD ERROR:
OCISt
mtExecute) at maneja_admin.plx line 591.
[mmacias@intranet hernan]$ perl maneja_admin.plx
Content-type: text/html

DBI bind_param: invalid number of parameters: handle + 4
Usage: $h->bind_param($parameter, $var [, \%attr]) at maneja_admin.plx line
591.

[mmacias@intranet hernan]$ perl maneja_admin.plx
Content-type: text/html

SQL type 1075461088 for '' is not fully supported, bound as SQL_VARCHAR
instead
at maneja_admin.plx line 591.
SQL type 1075461088 for '|H;#
                            ' is not fully supported, bound as SQL_VARCHAR
inste
ad at maneja_admin.plx line 592.



Saludos,
Hernán Moreno


Reply via email to