Re: ? PL/SQL: numeric or value error: character string buffer too small

ok, thanks. but
(dbms_lob.instr(lower(dbms_lob.substr(beschluss_text)), 'burg', 1, 1) != 0)

returns:
wrong number or types of arguments in call to 'INSTR' what i don't understand.

i need the lower, because i want to do somthing like select * from table where lower(column) like '%foo%', but column is a clob.

>
> at least 1 element in the column beschluss_text seams to be longer than
> varchar2 can be (about 32600)
> so you need either cut the column beschluss_text to that size (which
> would eventually influence your result)
> or you use DBMS_LOB.INSTR instead of making a varchar out of it and making
> a normal instr
Received on Wed Jul 04 2001 - 09:42:54 CDT