Invalid parsing schema for current workspace ID
I have an application that captures different SQL statements (they make use of DB links) and dynamically executes them on demand.
I use apex collections to get the result rows for the SQL and use them to both query on the UI as well as send out emails using the returned data. This is all OK and works fine.
I then added another feature to my application where I support the scheduling of the running the SQL / sending out of the emails. It uses the same logic as I use from within the application but it fails with the following error ...
Invalid parsing schema for current workspace ID
when the SQL is being used to populate the collection.
The scheduling is done using the apex plsql job scheduling package. It's as though the context that the job is running in is different from that of the application I created. The strange thing is that it can still see my tables that I created as the queries return data from my tables but for some reason seems to have an issue with the use of apex collections.
Any ideas or suggestions would be greatly appreciated.