Hi,

I am trying to create below stored procedure, but i am encountering error as
LINE/ COL ERROR
-------- ----------------------------------------------------
14/ 7 PL/SQL: Statement ignored
14/ 39 PLS-00302: component 'TestA ' must be declared

could you please assist on this

Create or replace procedure TestProc
as
BEGIN
DECLARE
v_file utl_file.file_type;
v_logfile VARCHAR2(100);
v_header varchar2(100);
BEGIN
v_logfile := 'TESTFILE_'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')||'.csv';
v_file := UTL_FILE.FOPEN('TEMP_DIR', v_logfile, 'w');
--v_header :='TestA, '||' TestB';
--UTL_FILE.PUT_LINE(v_file,v_header);
FOR e_rec IN (SELECT * FROM Test_Table) LOOP
UTL_FILE.PUT_LINE(v_file, e_rec.TestA ||','|| e_rec.TestB);
END LOOP;
UTL_FILE.FCLOSE(v_file);
END;
END;