RE: Perl - connecting to Oracle


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: mwelters@xxxxxxxxxx [mailto:mwelters@xxxxxxxxxx]
Sent: Tue 5/20/2008 4:04 PM
To: dbi-users@xxxxxxxx
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


Relevant Pages