Recent content by kmm_micha

Thanks a lot! It worked fine for me, but after a milion of silly tries we discovered other way: create table temp (teste clob); insert into temp select to_lob(search_condition) from sys.dba_constraints; select t.*, to_char(teste) from temp t;

Hi. When trying to convert a LONG column to a VARCHAR2 column in the following statement... -------------------------------- select to_char(search_condition) from sys.dba_constraints; -------------------------------- ... I get the following error: ---------------------------------------...

Wow, it works perfeclty.... on 10G version, but did not word on 9i. What code or file works on 9i?

Can you show me the code you use to compile invalid objects? Thanks and waiting answer!

I have an application that executes a sql with two with's. When I run this sql by pl/sql developer, it works fine, but when I run this sql by my application, using DOA, I get the error: Unimplemented Feature. How can I correct this? Thanks.