Oe 10.2b, 11.3, 11.5 Vs Oracle 12.1.0.2

[calbor]

How to connect any OE version with Oracle 12.1.0.2 and her "editioning objects".
We have OE DataServer for Oracle but this kind objects (edtioning) not is possible to update. Is there any parameter or thing considered for the connection?
The instance is on Sun Solaris - Unix 64 bits.
Regards!

 

[TheMadDBA]

Are you talking about editioning views?

 

[calbor]

Are you talking about editioning views?

Yes, the editioning views are part of the problem.

 

[TheMadDBA]

It would help to know which exact errors you are getting and an example object.

If they are multi table views then you are basically out of luck from a 4GL/ABL perspective. Currently those are only supported for read operations. Unless you bypass the 4GL (FOR EACH) and call stored procedures instead.

 

[calbor]

It would help to know which exact errors you are getting and an example object.

If they are multi table views then you are basically out of luck from a 4GL/ABL perspective. Currently those are only supported for read operations. Unless you bypass the 4GL (FOR EACH) and call stored procedures instead.

I am creating a holder schema, when I try to update and / or add new objects I can not see the edicionables views are only available objects belonging to the scheme with which I connect to Oracle DB (owner).

Somebody on Progress Support Chat, tell us that OE DataServer 11.6 is certified to this but, in Mexico not is available these version.

 

[TheMadDBA]

Not 100% sure the dataserver supports editioned views in 11.6... but you would need to make sure the user you are connecting as has the proper grants for the edition you care about.. either by setting the default edition for the database or by granting USE for that edition.

In addition you need to make sure that the user is using the proper edition when it first logs into the instance.

In my opinion you should never use any of the built in users to handle schema holders... make a user specific for the schema holder with the appropriate rights.