It instructs SAP ASE to compile a new plan, which is used for subsequent executions. In the execute statement, the optional clause with recompile comes after any parameters. A new plan is created each time the procedure is executed. It instructs SAP ASE not to save a plan for this procedure. In the create procedure statement, the optional clause with recompile comes immediately before the SQL statements. You can optionally use a semicolon and integer number after the name of a procedure in the create procedure, and execute statements, to group procedures of the same name so that they can be dropped together with a single drop procedure statement. You can declare a large object (LOB) text, image, or unitext datatype for a local variable, and pass that variable as an input parameter to a stored procedure. This value, which can be any constant, is used as the argument to the procedure if the user does not supply one.Įxamples are provided for using multiple parameters in a procedure. You can assign a default value for a parameter in the create procedure statement. The value of each parameter named in a create procedure statement must be supplied by the user when the procedure is executed. You can optionally declare one or more parameters in a create procedure statement. When deferred name resolution is active objects inside procedures are resolved at execution time, instead of at creation time.Ī parameter is an argument to a stored procedure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |