ORA-04043 WHEN USING SYNONYM FOR TYPE OBJECT WORKS FROM SQLPLUS

ORA-04043 WHEN USING SYNONYM FOR TYPE OBJECT WORKS FROM SQLPLUS

Postby klayme » Mon 05 May 2008 14:44

Hi. We have a problem when using private synonyms to access a type on another schema.
.NET application raises ORA-04043: object TBL_PROPOSALS does not exist. The same statement works ok in sqlplus, or in .NET app when the type used is referenced with the owner instead of the private synonym:

Not working:
Dim objOra As OracleObject
tblProposal = New OracleTable("tbl_Proposals", objConn)
objOra = New OracleObject("obj_Proposals", objConn)

Working ok:
Dim objOra As OracleObject
tblProposal = New OracleTable("typeowner.tbl_Proposals", objConn)
objOra = New OracleObject("typeowner.obj_Proposals", objConn)

Can you please tell us where is the problem? Thank you.
klayme
 
Posts: 1
Joined: Mon 05 May 2008 14:34

Postby Alexey.mdr » Mon 05 May 2008 15:17

We reproduced the problem and now we are fixing it.
Look forward to the next build.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby Alexey.mdr » Tue 06 May 2008 11:13

Hi!

Could you please try the following lines?
There were no problems detected with OraDirect .NET 4.60.33
and private synonym created as
Code: Select all
CREATE SYNONYM SCHEMA2.SYNONYMNAME for SCHEMA1.OBJECT1
With public synonyms created as
Code: Select all
CREATE PUBLIC SYNONYM SYNONYMNAME for SCHEMA1.OBJECT1
you have to add PUBLIC.
Code: Select all
objOra = New OracleObject("PUBLIC.obj_Proposals", objConn);
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for Oracle