Calling stored procedures

When used as a source of data in one of the database functions (DBQUERY or DBLOOKUP), in a GET function, or in a query defined in the Database Interface Designer, there are two ways to call stored procedures:

• Use the database-independent syntax for calls.

  This provides a means of accessing the output parameters and return values from stored functions.

• Use the native syntax for the database.

  Using this method, you cannot access output parameters or return values from stored functions.

In addition to the above methods, when using Oracle object types as parameters in stored procedures, there is a special syntax that must be used. For more information about this, see Stored Procedures with Object Type Parameters.