Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

DB_STORED_PROCEDURE_ARGS

Represents the argument information of Java stored procedures for which the current user has access authorization in the 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)

Definition

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 ;

Example

The following is an example of retrieving arguments the 'phone_info' Java stored procedure in the order of the arguments.

csql> select index_of, arg_name, data_type, mode 

csql> from  db_stored_procedure_args

csql> where sp_name = 'phone_info'

csql> order by index_of

csql> ;x

 

=== <Result of SELECT Command in Line 3> ===

 

     index_of  arg_name              data_type             mode               

===============================================================

            0  'name'                'STRING'              'IN'               

            1  'phoneno'             'STRING'              'IN'