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)

#3100

Alfred
Moderator

If you want to access stored procedures from more than one schema it is the correct solution to use “schema.package” as name of <<SQLPackage>>.

If you want to access stored procedures from a single schema you can specify the tag *schema* on the <<SQLAlias>>. This is explained in the example sqlStoredProcedures.xml.

Stored procedures in the schema of the user or changed with alter session can be placed in the <<SQLDatabase>> interface.