Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Synonyms and DBMS_SQL?
Has anyone else experienced any problems with running SQL DML via the PL/SQL package DBMS_SQL when the tables are referenced via synonyms?
I have some queries which fail in DBMS_SQL.PARSE (with Table or view does not exist error) but which work just fine in SQL*Plus. The referenced tables are mapped via synonyms to TableName = Schema.TableName. The queries just use TableName. DBMS_SQL works fine for tables which I own.
This would be a big inconvenience if DBMS_SQL won't work with synonyms.
-- ================================================= Jerry Apfelbaum email: japfelba_at_ican.ca Eastern Sun Group Inc. phone: 416.240.9695 Toronto, CanadaReceived on Fri Nov 07 1997 - 00:00:00 CST
![]() |
![]() |