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

  • Re: OID/LDAP problem - Any help with a fix would be appreciated
    ... occurs in a 9.2.0.6 Oracle database when using dblinks. ... Oracle's fix is ... to roll back to TNSNAMS or upgrade to 10G. ...
    (comp.databases.oracle.server)
  • Max number of cursors opened exceeded
    ... I have an ASP.Net web site built on C# that uses Oracle database, ... error message. ... How can I fix this? ...
    (microsoft.public.dotnet.languages.csharp)
  • System.Data.DataRowView problem
    ... I am trying to fill a datalist with table names from an Oracle database. ... private void GetTables() ... What do I need to change in the above code to fix this ... Dave ...
    (microsoft.public.dotnet.languages.csharp)