login with a period

jasond

Member
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?
 
I could not immediately reproduce this. To obtain some more diagnostic information, can you modify the shortcut and add the debug & debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.
 
Back
Top