This content has been marked as final. Show 6 replies
Hi ottkaresz ,
I opened the b14258.pdf (PL/SQL Packages and Types Reference) in which the DBMS_LOB package is described.
But in page 969 on this document -overview segment - it says that this package reads and modifies BLOB,CLOB,NCLOB datatype.
Also in pages 986-987 where the COMPARE function is described , this function takes as arguments only BLOB , CLOB , BFILE - there is not reference to LONG datatype!!!!
Should I first convert the LONG datatypes to (C/N)LOB BEFOREHAND I DO THE COMPARISON..., or what else should I do?
the url http://www.trendo-kft.hu directs to a site , the language of which , is unknown for me.
Is there the capability to interpret it in English...!
Thanks , a lot
Sorry for misunderstanding you.
Use the TO_LOB function to convert the long to lob:
Sorry for the language restriction of my web page but this is only the first version :-)
I think I cannot use it because as the link you sent me says
'....You can apply this function only to a LONG or LONG RAW column, and only in the select list of a subquery in an INSERT statement.'
But , I want to compare to LONG datatype values. One value is within the column SEARCH_CONDITION of user_constraints view and the other is a value (string) which i construct according to the db error (not null constraint) which raises....
Thanks , anyway ,