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

Reply via email to