create function(tablename in varchar2)
as

select * from tables where table_name = tablename(input parameter)

CREATE OR REPLACE FUNCTION writeMetaDetail(tablename IN VARCHAR2,count_rows IN NUMBER) RETURN NUMBER
AS

  BEGIN

FOR meta IN(SELECT  COLUMN_NAME FROM all_tab_columns  WHERE table_name = :tablename
                                ORDER BY column_id ) 
										
LOOP

UTL_FILE.PUT(OutMetaFile, meta.COLUMN_NAME ||'|');


END LOOP;

OPEN <refcursor> FOR 'querystring'

CREATE OR REPLACE FUNCTION writeDataToFile(p_tablename IN VARCHAR2) 
RETURN UTL_FILE.FILE_TYPE
AS
v_OutFile  UTL_FILE.FILE_TYPE;
v_FileName  VARCHAR2(400);
v_startDate DATE;
v_count_rows       PLS_INTEGER := 0;
v_seperator CHAR(1) := NULL;
sql_stmt  VARCHAR2(500);


BEGIN

v_FileName := ('00000001_' || TO_CHAR(SYSDATE,'yyyymmddhhmiss') || '_' || p_tablename || '.txt');
v_OutFile := UTL_FILE.FOPEN('ORALOAD', v_FileName, 'w');
v_startDate := SYSDATE;

FOR meta IN(SELECT  column_name FROM all_tab_columns  WHERE table_name = p_tablename
                              ORDER BY column_id ) 
										
LOOP

FOR rec IN (SELECT * FROM p_tablename WHERE Request_id IN(66,145,147))

LOOP
 UTL_FILE.PUT(v_OutFile,is_blank(rec.meta.column_name) || '|' );

end loop;
end loop;