E2E Forum › General Discussion › access a stored procedure in a different schema (Oracle) › Reply To: access a stored procedure in a different schema (Oracle)
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?
PS: whether this is a bug or a feature I can’t tell. Someone from the core dev team will have to answer that.