HELP! Problems with Long data type.

I got a table with a long column and when I am trying to execute following statements several errors occured:

	declare 
		buffer long; 
       begin
     	 	select comment into buffer from sample_table where id=1;
       end;
      
	ORA-06502: PL/SQL: numeric or value error
	ORA-06512: at line 4

or

	select length(comment) from from sample_table where id=1;
       	       *
	ORA-00932: inconsistent datatypes

The statements work on 7.3.x but now we are using 8.0.4 and it does not work!
Does anyone have an idea why operations on long datatype force such errors? Why it is supported on Oracle 7.3.x?

Thx in advance.

--
Bogdan Stepien
mailto:stepien_at_tpg.pl Received on Wed Feb 24 1999 - 02:59:40 CST