bildwelt
E2E FORUM
E2E Bridge E2E Commerce

Reply To: access a stored procedure in a different schema (Oracle)

E2E Forum General Discussion access a stored procedure in a different schema (Oracle) Reply To: access a stored procedure in a different schema (Oracle)

#3096

Dirk
Moderator

Hi Ingo,

The schema is set on the SQLAlias, so the easiest way to achieve this would be to define a separate SQLAlias pointing to the other schema, and use this Alias in that SQLAdapter call.

If that’s not an option, you could try naming the SQLPackage by prepending the schema name, e.g. ‘OtherSchema.PackageName’. Not sure if it works, and I don’t have an Oracle DB within reach to test it right now. But should be quick to find out.

Does that help?
Dirk

PS: whether this is a bug or a feature I can’t tell. Someone from the core dev team will have to answer that.