RE: Connect to Oracle 8.1.7

From: Graeme St. Clair (Graeme.St.Clair_at_hds.com)
Date: 01/25/05 

To: dbi-users@perl.org
Date: Tue, 25 Jan 2005 08:10:35 -0800

The <*> is a tag that Oracle inserts into the error message, just before the
SQL character or word that it thinks is raising the error. For example:-

ORA-00904: invalid column name (DBD: error possibly near <*> indicator at
char 46 in 'select honk, bang from my_barking_db where <*>honk in
('arf','bowwow')')

This string is returned as $DBI::errstr.

Rgds, GStC.

 

-----Original Message-----
From: Spiraquis Alexis (SFO) [mailto:spiraqua@telefonica.com.ar]
Sent: Monday, January 24, 2005 1:45 PM
To: dbi-users@perl.org
Subject: Connect to Oracle 8.1.7

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.