Create and Execute Stored Procedures

You can create a procedure in the current database.

In versions of SAP ASE earlier than 15.5, all referenced objects where required to exist when a procedure was created. The deferred name resolution feature allows objects, except for user-created datatype objects, to be resolved when the stored procedure is initially executed.

Deferred name resolution uses the deferred name resolution configuration parameter, which operates at the server level, or set deferred_name_resolution parameter, which operates at the connection level.

The default behavior is to resolve the objects before execution. You must explicitly indicate deferred name resolution using the configuration option deferred name resolution, or the set parameter.

See the System Administration Guide: Volume 1, and the Reference Manual: Commands.

Permission to issue create procedure defaults to the database owner, who can transfer it to other users.