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:[EMAIL PROTECTED] 
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.

Reply via email to