Hello,
We have some java code which is published as a package in oracle. We have this piece of code:

Statement createTempTable = getConnection().createStatement();
createTempTable.execute("create table store_list_dups as select * from store_list where rownum < 0");
createTempTable.close();
When we execute the published package, it is able to create this table. But the same package if its executed as a DBMS_JOB it throws this message.

oracle.jdbc.driver.OracleSQLException: ORA-01031: insufficient privileges.

Could someone shed some light over this issue: