I have been trying to update some old Perl code to fix a web page that prints
data from an Oracle database.
Whenever I run the file I get an error. It is:
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
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
I am stuck, and do not know why it is not running.
Any help would be greatly appreciated.
Thank you,
Matthew Welters
