DBMS_AQ [message #643202] |
Thu, 01 October 2015 03:49 |
suyogsheth
Messages: 18 Registered: November 2009 Location: Pune
|
Junior Member |
|
|
Hi All,
We have migrated from 8i to 10g, we also have compiled all PLSQL and Pro*C code into 10g everything is working fine expect a Pro*C program.
When executing it gives an error:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_AQ", line 1
This Pro*C code just have an update statement, also we have not used DBMS_AQ anywhere in program as 8i did not have any advance queuing functionality.
I think Oracle is calling DBMS_AQ explicitly.
DBA's have tried to give privilage:
grant execute on sys.dbms_aq to user;
But still the same issue.
Please advice.
Thanks In Advance.
|
|
|
Re: DBMS_AQ [message #643203 is a reply to message #643202] |
Thu, 01 October 2015 03:54 |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You say "migrated", did you use export/import? If so, you may be missing grants and objects that existed in the SYS schema.
Is there a DML trigger on the table you are updating?
|
|
|
Re: DBMS_AQ [message #643206 is a reply to message #643203] |
Thu, 01 October 2015 04:02 |
suyogsheth
Messages: 18 Registered: November 2009 Location: Pune
|
Junior Member |
|
|
Hi John
I don't have any Idea, who the database has migrated.
Yes there is trigger before Update on table which inserts into audit and history tables.
|
|
|
Re: DBMS_AQ [message #643207 is a reply to message #643206] |
Thu, 01 October 2015 04:04 |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You don't know how you "migrated" it? You could ask, you know. If things don't work after this "migration", clearly it was not done correctly.
And what happens if you disable the trigger?
|
|
|
|