Thread: Why not (OID) in JDeveloper10g?

Hello!,
Using JDeveloper10g (ORACLE) I can connect to PostgreSQL database
on local machine;
BUT! when trying to open informations on table structure, I receive this ER=
ROR=20
MESSAGE=20
***************************************************************************=
******
See image attached!






***************************************************************************=
******
and I'can't access table structure informations (I.E. ftable.fields list)!


This is what says Oracle about this same error on his help on line into=20
JDeveloper10g.
***************************************************************************=
**************
Cause: A database failure occurred while trying to generate an object ID (O=
ID)=20
and object reference (REF). When a new row is created on an entity which ma=
ps=20
to an Oracle object table, an OID and REF for the new row are generated. Th=
is=20
executes a SQL statement like select a.oid, make_ref(, a.oid) ... Somehow,=
=20
this statement is failing. Action: Check the following: Are you using the=
=20
right version of Oracle database? Is the table in question an object table?=
=20
This error normally carries a detail exception from the database, which wil=
l=20
give further information about the database failure. Take a look at the=20
detail exception and address the database problem.=20
***************************************************************************=
*************
Do anyone knows why this happen?, is it possible to correct already the=20
problem?, or anyone does encountered the same problem?=20
--=20
Roberto Della Grotta

On Tue, 27 Jan 2004, rdgmus wrote:

> Hello!,
> Using JDeveloper10g (ORACLE) I can connect to PostgreSQL database
> on local machine;
>
> This is what says Oracle about this same error on his help on line into
> JDeveloper10g.
> *****************************************************************************************
> Cause: A database failure occurred while trying to generate an object ID (OID)
> and object reference (REF). When a new row is created on an entity which maps
> to an Oracle object table, an OID and REF for the new row are generated. This
> executes a SQL statement like select a.oid, make_ref(, a.oid) ... Somehow,
> this statement is failing. Action: Check the following: Are you using the
> right version of Oracle database? Is the table in question an object table?
> This error normally carries a detail exception from the database, which will
> give further information about the database failure. Take a look at the
> detail exception and address the database problem.
> ****************************************************************************************

I'm not sure where you got the idea that oracle's product supports
postgresql.  If it is supposed to support pg, then the place to file the
bug report would be oracle, not here.  Because it uses JDBC you can
probably get a connection to any database, but that doesn't mean it will
actually work.

Kris Jurka