DBD:Oracle Selecting Clobs

[nationavon]

My sql statement looks like this:

SELECT TICK_NUM FROM TICKET_RESO WHERE TICK_GROUP_ID='0' AND TICK_STAT='1' AND TICK_RESO='Not Specified';

The TICK_RESO field is a clob. If I remove AND TICK_RESO='Not Specified' from the statement everything it works. Any help would be appreciated.

 

[hmerrill]

How about some info like

- what database are you using
- are you using DBI/DBD::XYZ where XYZ is the acryonym representing your database
- what platform, version of perl, etc.

Can you also show the actual piece of code that is failing?
Hardy Merrill
Mission Critical Linux, Inc.

http://www.missioncriticallinux.com