sql>select * from blob_test; (in 10g)
error
SP2-0678: Column or attribute type can not be displayed by SQL*Plus
solve (try this)
-------
select utl_raw.cast_to_varchar2(a) from blob_test;
-- where 'a' is column_name and 'blob_test' is table_name
error
SP2-0678: Column or attribute type can not be displayed by SQL*Plus
solve (try this)
-------
select utl_raw.cast_to_varchar2(a) from blob_test;
-- where 'a' is column_name and 'blob_test' is table_name
No comments:
Post a Comment