jeristotle
asked on
SELECT query fails when LONG RAW field is empty. How do I compensate for this?
Hi.
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?
Short version:
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.
Many thanks,
jeristotle
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?
Short version:
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.
Many thanks,
jeristotle
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll have to check to see what version is running. Thanks the help. I'll post results later.