You can create a procedure in the current database only.
In versions of Adaptive Server earlier than 15.5, it was necessary for all the referenced objects to exist at creation time. The deferred name resolution feature now allows objects, except for user-created datatype objects, to be resolved when the stored procedure is executed for the first time.
This feature, deferred name resolution, operates using a new configuration parameter, deferred name resolution, which operates at the server level, or a new set parameter, set deferred_name_resolution, which operates at the connection level.
The default behavior is to resolve the objects before execution (old behavior). You must indicate the new behavior by explicitly indicating the configuration option deferred name resolution, or the set parameter .
For documentation of these parameters 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. See the Reference Manual: Commands.
