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
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center