application code - APPS schema
custom code - XXG schema
code tester - XXG_CODE_TESTER schema
I am testing a packaged procedure in APPS schema. One of the arguments is pi_claim_rec IN xxg_interface_stg%ROWTYPE
xxg_interface_stg table is created under the XXG schema and being referenced with a synonym in APPS schema where the actual packaged procedure being tested resides. I do NOT want to add xxg. prefix to the argument in procedure nor do i want to prefix it with APPS
XXG_CODE_TESTER has all the privileges on xxg_interface_stg table and execute priv on APPS. other tests are running fine.
When i create a test there is a compile time error
PLS-00201: identifier ‘XXG.APPS’ must be declared
PL/SQL: Item ignored
PLS-00313: ‘S_PI_CLAIM_REC$1’ not declared in this scope
If i copy the body of generated test code to TOAD, remove the duplicate schema.schema reference the code compiles fine but it doesn’t help
With every new test case added the test code keeps getting overwritten with latest test code being generated
When the test is run it says “No test results available at this level” under the results tab
Under Properties tab test code compilation status keeps going invalid after the run even though i just compiled successfully after removing XXG.APPS.
Is this a known issue ? How can i get around this please ? I am using trial version code tester 22.214.171.124 part of Toad Oracle Expert 11.6 2017