Toad World® Forums

How to use QCTO for SPs in different schema?

Hi,
I am working in a MNC. I am doing POC for QCTO (on Trial version v-2.0.0.582).
My requirement is - we are getting multiple QA builds (which may have different
schema/database).

I did following steps :

  1. Created a simple procedure which returns out ref cursor. (e.g. in QTCO
    schema)
  2. Wrote simple test case to return all rows and executed. It worked fine.

Now I tried to apply my requirement :
3. Dropped procedure and table from that schema.
4. Created same procedure and table along with data in different schema
5. Granted all rights to QTCO schema.
6. Created synonym for procedure and table.
7. When i m executing same test case, it is failing test case and removing test
case from that list.

Can anybody please suggest what to do?

Thanks,
Deval