convert long to varchar
654808Sep 18 2008 — edited Sep 18 2008Hi all. Why am I getting this error? :_|
create or replace function mike.getHighValue(
p_owner varchar2,
p_table varchar2,
p_part_name varchar2
) return varchar2 as
l_data long;
begin
select high_value into l_data from dba_tab_partitions
where table_owner = p_owner
and table_name=p_table
and partition_name=p_part_name;
return substr( l_data, 1, 4000 );
end;
------
select mike.getHighValue( high_value) from dba_tab_partitions;
ORA-00997: illegal use of LONG datatype