I'm having issues with of my stored procs and an Add Duplicate Row test. It counts the table before and after the SP. The test just inserts some values into the table and the outcome, I check to see if the count is > 0. I am the owner of the object I'm testing. QCTO was set up using our prod account and the code I'm testing is using the prod_report account. I'm logged into as prod_report account.
I create the test without any problems, but when i click Generate Test Code on the dashboard I get the error:
********************************************************
Oracle Error General
Error code : 10000002
Error name : UNANTICIPATED-ERROR
Error details :
Execute DDL statements dynamic SQL failure
An unanticipated error has occurred. Please review the information below and see if it will help you resolve the problem.
CODE-EXECUTED =
ERROR-INFO =
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "RF3_PROD_1.QU_TEST", line 157
********************************************************
Oracle Error Advanced
System error code : -1031
System error message :
ORA-01031: insufficient privileges
Error stack :
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "RF3_PROD_1.QU_TEST", line 157
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center