Chapter 9 SQL Statements
453
CREATE PROCEDURE statement
Use this statement to create a procedure in the database.
CREATE PROCEDURE [
owner
.]
procedure-name
( [
parameter
, … ] )
{ [ RESULT (
result-column
, … ) ]
… [ ON EXCEPTION RESUME ]
…
compound-statement
| AT
location-string
| EXTERNAL NAME
library-call
| [ DYNAMIC RESULT SETS
integer-expression
]
… EXTERNAL NAME
java-call
LANGUAGE JAVA
}
parameter
:
parameter_mode
parameter-name
data-type
[ DEFAULT
expression
]
| SQLCODE
| SQLSTATE
parameter_mode
:
IN | OUT | INOUT
result-column
:
column-name
data-type
library-call:
'[
operating-system
:]
function-name
@
library.dll
; …'
operating-system:
Windows95 | WindowsNT | NetWare | UNIX
java-call:
'[
package-name
.]
class-name
.
method-name
method-signature
'
method-signature
:
( [
field-descriptor
, … ] )
return-descriptor
field-descriptor
|
return-descriptor
:
Z | B | S | I | J | F | D | C | V | [
descriptor
| L
class-name
;
Must have RESOURCE authority.
Must have DBA authority for external procedures or to create a procedure
for another user.
Automatic commit.
"BEGIN statement" on page 404
"CALL statement" on page 410
"CREATE FUNCTION statement" on page 445
"CREATE PROCEDURE statement" on page 460
"DROP statement" on page 505
"EXECUTE IMMEDIATE statement" on page 518
Function
Syntax
Permissions
Side effects
See also
To Next Page
Loading...