Apologies in advance; this is my first post.
We have a trigger on a delete that invokes a Java stored procedure (JSP). That uses jdbc to do "select mysequence.nextval from dual", and I get an insufficent privileges error.
Any ideas?
Printable View
Apologies in advance; this is my first post.
We have a trigger on a delete that invokes a Java stored procedure (JSP). That uses jdbc to do "select mysequence.nextval from dual", and I get an insufficent privileges error.
Any ideas?
Make sure that the user has privilege on mysequence (you can test that from sqlplus by running that select statement, but remember that it'll increase the value of the sequence by one). In case there is no privilege problem with the sequence then you may try granting the JAVAUSERPRIV to the user from the system account.
Thanks.
Syed