Hi, I always quote (qq) the select string to escape it from local interpretation, then feed it to the 'prapre' statement.
Rick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 5/20/2008 4:04 PM To: [email protected] Subject: Perl - connecting to Oracle 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
