| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LONG RAW - accessing data
in my humble opinion you don't need anything stronger at all;
seems like you have (at least) two good reasons to change from LONG RAW to CLOB.
1. thou shall not use LONG anymore, but use LOB types instead
2. don't store text in a RAW column, because it prevents
(in this case apparently desired :-) interpretation.
don't fight the symptoms -- solve the problem! kind regards,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of David cheyne
Sent: Thursday, February 24, 2005 15:15
To: oracle-l_at_freelists.org
Subject: LONG RAW - accessing data
Hi,
A developer I work with is trying to access a column that is defined as LONG
RAW.
This is a 3rd party application and the column only stores text.
When queried through sqlplus the number '3' is returned, When queried through Oracle reports the number '9' is returned. Within the application the full text(it's used a a notes field) is shown.
I can only assume that this is not readable in PL/Sql and we may need something stronger,: java, C or the like to handle the output.
The developer has placed a iTar for this but so far, after 6 days ..nothing!
Your thoughs.
Oracle Database Administrator
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 24 2005 - 11:03:56 CST
 |
 |