I've created a package from a script a user made to execute sql statements. I ran the scripts in my schema so that I have enough priviledges. When I compile the package spec all is good. When I compile the body I get a Hint comment stating value assigned to 't_execution_status' never used in 'EXECUTE_SQL' and 'DELETE_TABLE'. Then I execute the package at the sql prompt with exec mail_data_extract.populate_mail_data. I get the following errors:
ORA-00904: invalid column name
ORA-06512: at "SYS.DBMS_SYS_SQL", line 824
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "GSAN.MAIL_DATA_EXTRACT", line 13
ORA-06512: at "GSAN.MAIL_DATA_EXTRACT", line 63
ORA-06512: at line 1
With the first error there shouldn't be an invalid column name because I ran the script the user made at the sql command prompt and I didn't get that error.
What am I doing wrong. Please help.