Long타입 To_char형태로 변환

Long Type을 To_char로 바꿀수 있는 함수!

 

create or replace FUNCTION          LONG_TO_CHAR( in_rowid rowid,in_owner
varchar,in_table_name varchar,in_column varchar2)
RETURN varchar
IS
 text_c1 varchar2(32767);
 sql_cur varchar2(2000);
BEGIN
  sql_cur := 'select '||in_column||' from
'||in_owner||'.'||in_table_name||' where rowid =
'||chr(39)||in_rowid||chr(39);
  dbms_output.put_line (sql_cur);
  execute immediate sql_cur into text_c1;
  Return text_c1;
END;