Connect to Oracle 8.1.7
From: Spiraquis Alexis (spiraqua_at_telefonica.com.ar)
Date: 01/24/05
- Previous message: Hernan Arredondo: "Affected Rows"
- Next in thread: David N Murray: "Re: Connect to Oracle 8.1.7"
- Reply: David N Murray: "Re: Connect to Oracle 8.1.7"
- Maybe reply: Graeme St. Clair: "RE: Connect to Oracle 8.1.7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: dbi-users@perl.org Date: Mon, 24 Jan 2005 15:44:31 -0300
Hello
I have on my server 5.005_03 built for sun4-solaris installed with
DBI(v1.13). I was previously accesing a Oracle 7.3.4 Database without
problems. Now I tried to access the same DB but migrated to 8.1.7 and I get
the following error:
DBD::Oracle::db prepare failed: ORA-00942: table or view does not exist
(DBD: error possibly near <*> indicator at char 52 in ' select m.swValue
There is no "<*>" in my query and the same Perl page with Oracle 7.3.4
works.
What I guess is that I use two types of connections. With this type I donīt
have any problems:
sub adv_connect
{
#local ($sql, @inputdata) = @_ ;
local ($dbh) = DBI->connect('dbi:Oracle:dbname','user','pass',
);
$dbh->{AutoCommit} = 0;
return ($dbh);
}
But with this type of connection I get the error mentioned above:
sub adv_connection
{
local ($sql, @inputdata) = @_ ;
local ($dbh) = DBI->connect('dbi:Oracle:dbname','user','pass',
);
$dbh->{AutoCommit} = 0;
local ($sth) = $dbh->prepare($sql) or return ($dbh,undef);
$sth->execute();
$sth->bind_columns(undef, @inputdata);
return ($dbh, $sth);
}
The question is: Do I need to change all these types of connections and use
the first one? Or I need to migrate the Perl or DBI version?
Thank you very much
- Previous message: Hernan Arredondo: "Affected Rows"
- Next in thread: David N Murray: "Re: Connect to Oracle 8.1.7"
- Reply: David N Murray: "Re: Connect to Oracle 8.1.7"
- Maybe reply: Graeme St. Clair: "RE: Connect to Oracle 8.1.7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
