I have a db login ama_dev_4.0. This works fine in Oracle sqlplus, but when I run a query that uses types, pl/sql developer cannot recognize the type. I get the error below:
ORA-04043: object AMA_DEV_4.0.PLAN_T does not exist
The sql is 'select * from table(StatementDataSet_t(getStatementData('Scenario1')))'
I am logged in as the schema owner ama_dev_4.0. Is there a way to get around this in pl/sql developer or do I just have to rebuild the schema?
ORA-04043: object AMA_DEV_4.0.PLAN_T does not exist
The sql is 'select * from table(StatementDataSet_t(getStatementData('Scenario1')))'
I am logged in as the schema owner ama_dev_4.0. Is there a way to get around this in pl/sql developer or do I just have to rebuild the schema?