ТЕМА:

create table test (

    test_id number(9)

  , ldata long

  , constraint pk_test primary key (test_id)

)

/

insert into test (test_id, ldata) values (1, '123456ABC');

commit;



create or replace function ldata2varchar (

  p_test_id number

) return varchar2 as

  v varchar2(32765);

begin

  execute immediate 'begin select ldata into :v from test where test_id = :test_id; end;'

  using out v, p_test_id;

  return v;

end;

/

select ldata2varchar(1) from dual;