special characters in schema name

PeterJ

Member
If I right click on a table in the browser to query data when the table is in another schema than the one I am logged into and that other schema starts with '#', then the resulting sql window gets ORA-00911:invalid character.
Is there something I can do to make PL/SQL Developer (6.04) double_quote and capitalise the schema name?
eg: 'select * from #user.tablename' needs to be 'select * from "#USER".tablename'
 
I am running into a similar problem, getting ORA-00911 when trying to REVOKE object privileges from a ROLE with a name of _IME_TEST. I modified the SQL to enclose the Role name in "" to make it "_IME_TEST" and it ran OK.
 
Back
Top