Kbase P45312: How parameters are passed in an SQL-92 stored procedure.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/21/2005 |
|
Status: Unverified
GOAL:
How parameters are passed in an SQL-92 stored procedure.
FACT(s) (Environment):
Progress 9.1x
FIX:
Parameter declarations specify the name and type of parameters that the calling application will pass and receive from the procedure. Parameters can be input, output, or both.
SYNTAX
{ IN | OUT | INOUT } parameter_name data_type
Example:
CREATE PROCEDURE new_sal (
IN deptnum INTEGER,
IN pct_incr INTEGER
)
RESULT (
empname CHAR (20),
oldsal NUMERIC,
newsal NUMERIC
)
IMPORT
import java.dbutils.SequenceType;
BEGIN
.
.
.
END