Represents argument information of Java stored procedure for which the current user has access authorization to a database.
Attribute Name |
Data Type |
Description |
---|---|---|
sp_name |
VARCHAR(255) |
Stored procedure name |
index_of |
INTEGER |
Order of the arguments |
arg_name |
VARCHAR(256) |
Argument name |
data_type |
VARCHAR(16) |
Data type of the argument |
mode |
VARCHAR(6) |
Mode (IN, OUT, INOUT) |
CREATE VCLASS db_stored_procedure_args (sp_name, index_of, arg_name, data_type, mode)
AS
SELECT sp.sp_name, sp.index_of, sp.arg_name,
CASE sp.data_type WHEN 28 THEN 'CURSOR'
ELSE ( SELECT dt.type_name FROM _db_data_type dt
WHERE sp.data_type = dt.type_id) END,
CASE WHEN sp.mode = 1 THEN 'IN' WHEN sp.mode = 2 THEN 'OUT'
ELSE 'INOUT' END
FROM _db_stored_procedure_args sp
ORDER BY sp.sp_name, sp.index_of ;
The following example shows how to retrieve arguments the 'phone_info' Java stored procedure in the order of the arguments.
SELECT index_of, arg_name, data_type, mode FROM db_stored_procedure_args
WHERE sp_name = 'phone_info'
ORDER BY index_of
index_of arg_name data_type mode
===============================================================
0 'name' 'STRING' 'IN'
1 'phoneno' 'STRING' 'IN'