No the <*> is DBI way of pointing to where the error is. It actully looks like you DBD::Oracle is working as expected. ORA-00904 is caused by an invaild field name.
My guess someone changed the infadmin.inv_stations table and it no longer has a staion_id or it is not the same type as infadmin.inv_hosts.station_id or you have corrupt data on your db. See if you can run the query in SQLPlus or alike. Cheers >> prepare: QUERY STATION: ORA-00904: invalid character (DBD ERROR: error >> possibly >> near <*> indicator at char 277 in ' >> SELECT loc.building, >> loc.room, >> sta.station, >> host.host_name, >> host.ip, >> loc.phone >> FROM infadmin.inv_locations loc, >> infadmin.inv_stations sta, >> infadmin.inv_hosts host >> WHERE loc.location_id = sta.location_id >> AND <*>sta.staion_id = host.station_id > > Is there a typo here? should it be sta.station_id= host.station_id > > >> AND loc.building = :bldg >> AND loc.room = :room >> AND sta.station = :station >> ORDER BY loc.building, loc.room, sta.station >> ') at print.pl line 94 >> > > Michael > >
