Monday, July 23, 2012

table or view does not exist

Just to share out something about Oracle during implementation of Maximo in my client. I was doing some integration between Maximo and MQ. As there is no clear way of doing integration between Maximo and MQ, we decided to use DB as the endpoint of Maximo integration to MQ. The data is only one way, that is from MQ to Maximo.We use Oracle package which runs every 8 am and 5 pm every day.

The things came up when I created stored procedure from other schema. If we test the query in the schema (not in stored procedure), it was smoothly being executed, but if we apply it in the stored procedure. The stored procedure wont be able to be compiled with error of nonexistence of table. Granting privilege will solve the problem

No comments: