I'm having a problem with an ASP page that's making a SQL call to an Oracle DB. The table contains a column that's LONG RAW and houses images. I pull records based on an Article Id. When the Article record contains an image, the select statement I use executes without issue. If the record has no image, the statement itself fails. (I've traced it back to the statement.) However, if I substitute NULL for that field, it works every time. (Just testing.)
Does anyone know why a simple select statement would fail if a LONG RAW column is empty for a row? And if so, how do I counter this behavior?
SELECT ARTICLE_ID, ARTICLE_IMAGE FROM ARTICLES WHERE ARTICLE_ID = 12345
Again, fails when ARTICLE_IMAGE is empty.
I'm new to Oracle, would really appreciate any help.