procedure.out

derby database source code.good for you.

    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
  SQLC.SQLCONTROL2_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
  SQLC.SQLCONTROL2_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
  SQLC.SQLCONTROL2_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
  SQLC.SQLCONTROL2_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl2 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
------------
DEFINED PROCEDURES FOR SQLCONTROL3_%
  SQLC.SQLCONTROL3_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
  SQLC.SQLCONTROL3_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  SQLC.SQLCONTROL3_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL
  SQLC.SQLCONTROL3_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA
  SQLC.SQLCONTROL3_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3(OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
DATABASE METATDATA PROCEDURES FOR SQLCONTROL3_%
  SQLC.SQLCONTROL3_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
  SQLC.SQLCONTROL3_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
  SQLC.SQLCONTROL3_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
  SQLC.SQLCONTROL3_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
  SQLC.SQLCONTROL3_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl3 type procedureNoResult
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
------------
DEFINED PROCEDURES FOR SQLCONTROL4_%
  SQLC.SQLCONTROL4_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
  SQLC.SQLCONTROL4_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  SQLC.SQLCONTROL4_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL
  SQLC.SQLCONTROL4_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA
  SQLC.SQLCONTROL4_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4(IN SQLC INTEGER,OUT E1 VARCHAR(128),OUT E2 VARCHAR(128),OUT E3 VARCHAR(128),OUT E4 VARCHAR(128),OUT E5 VARCHAR(128),OUT E6 VARCHAR(128),OUT E7 VARCHAR(128),OUT E8 VARCHAR(128)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
DATABASE METATDATA PROCEDURES FOR SQLCONTROL4_%
  SQLC.SQLCONTROL4_0 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
    procedureColumnIn SQLC INTEGER
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
    procedureColumnOut E8 VARCHAR
  SQLC.SQLCONTROL4_1 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
    procedureColumnIn SQLC INTEGER
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
    procedureColumnOut E8 VARCHAR
  SQLC.SQLCONTROL4_2 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
    procedureColumnIn SQLC INTEGER
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
    procedureColumnOut E8 VARCHAR
  SQLC.SQLCONTROL4_3 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
    procedureColumnIn SQLC INTEGER
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
    procedureColumnOut E8 VARCHAR
  SQLC.SQLCONTROL4_4 AS org.apache.derbyTesting.functionTests.util.ProcedureTest.sqlControl4 type procedureNoResult
    procedureColumnIn SQLC INTEGER
    procedureColumnOut E1 VARCHAR
    procedureColumnOut E2 VARCHAR
    procedureColumnOut E3 VARCHAR
    procedureColumnOut E4 VARCHAR
    procedureColumnOut E5 VARCHAR
    procedureColumnOut E6 VARCHAR
    procedureColumnOut E7 VARCHAR
    procedureColumnOut E8 VARCHAR
------------
** SQL ** DEFAULT (MODIFIES SQL DATA)
    CREATE TABLE SQ-UPDATE 0-EXECUTE OK
    ALTER TABLE SQL-UPDATE 0-EXECUTE OK
    INSERT INTO SQL-UPDATE 1-EXECUTE OK
    UPDATE SQLC.SQL-UPDATE 2-EXECUTE OK
    SELECT * FROM S- ROW(15)- ROW(12)-EXECUTE OK
    DELETE FROM SQL-UPDATE 2-EXECUTE OK
    DROP TABLE SQLC-UPDATE 0-EXECUTE OK
    CREATE VIEW SQL-42X05
    DROP VIEW SQLCO-X0X05
    LOCK TABLE SQLC-42X05
    VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
    SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
    CREATE SCHEMA S-UPDATE 0-EXECUTE OK
    DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
    IBM CS FEATURE
    IBM CS FEATURE
    SET ISOLATION C-UPDATE 0-EXECUTE OK
    SET RUNTIMESTAT-42X01
    SET STATISTICS -42X01
    VALUES 1- ROW(1)-EXECUTE OK
    VALUES 1- ROW(1)-EXECUTE OK
** SQL ** NO SQL
    CREATE TABLE SQ-38001
    ALTER TABLE SQL-42Y55
    INSERT INTO SQL-42X05
    UPDATE SQLC.SQL-42X05
    SELECT * FROM S-42X05
    DELETE FROM SQL-42X05
    DROP TABLE SQLC-42Y55
    CREATE VIEW SQL-42X05
    DROP VIEW SQLCO-38001
    LOCK TABLE SQLC-42X05
    VALUES 1,2,3-38001
    SET SCHEMA SQLC-38001
    CREATE SCHEMA S-38001
    DROP SCHEMA SQL-38001
    IBM CS FEATURE
    IBM CS FEATURE
    SET ISOLATION C-38001
    SET RUNTIMESTAT-42X01
    SET STATISTICS -42X01
    VALUES 1-38001
    VALUES 1-38001
** SQL ** CONTAINS SQL
    CREATE TABLE SQ-38002
    ALTER TABLE SQL-42Y55
    INSERT INTO SQL-42X05
    UPDATE SQLC.SQL-42X05
    SELECT * FROM S-42X05
    DELETE FROM SQL-42X05
    DROP TABLE SQLC-42Y55
    CREATE VIEW SQL-42X05
    DROP VIEW SQLCO-38002
    LOCK TABLE SQLC-42X05
    VALUES 1,2,3-38004
    SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
    CREATE SCHEMA S-38002
    DROP SCHEMA SQL-38002
    IBM CS FEATURE
    IBM CS FEATURE
    SET ISOLATION C-UPDATE 0-EXECUTE OK
    SET RUNTIMESTAT-42X01
    SET STATISTICS -42X01
    VALUES 1-38004
    VALUES 1-38004
** SQL ** READS SQL DATA
    CREATE TABLE SQ-38002
    ALTER TABLE SQL-42Y55
    INSERT INTO SQL-42X05
    UPDATE SQLC.SQL-42X05
    SELECT * FROM S-42X05
    DELETE FROM SQL-42X05
    DROP TABLE SQLC-42Y55
    CREATE VIEW SQL-42X05
    DROP VIEW SQLCO-38002
    LOCK TABLE SQLC-42X05
    VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
    SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
    CREATE SCHEMA S-38002
    DROP SCHEMA SQL-38002
    IBM CS FEATURE
    IBM CS FEATURE
    SET ISOLATION C-UPDATE 0-EXECUTE OK
    SET RUNTIMESTAT-42X01
    SET STATISTICS -42X01
    VALUES 1- ROW(1)-EXECUTE OK
    VALUES 1- ROW(1)-EXECUTE OK
** SQL ** MODIFIES SQL DATA
    CREATE TABLE SQ-UPDATE 0-EXECUTE OK
    ALTER TABLE SQL-42Y55
    INSERT INTO SQL-42X05
    UPDATE SQLC.SQL-42X05
    SELECT * FROM S-42X05
    DELETE FROM SQL-42X05
    DROP TABLE SQLC-42Y55
    CREATE VIEW SQL-42X05
    DROP VIEW SQLCO-X0X05
    LOCK TABLE SQLC-42X05
    VALUES 1,2,3- ROW(1)- ROW(2)- ROW(3)-EXECUTE OK
    SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
    CREATE SCHEMA S-UPDATE 0-EXECUTE OK
    DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
    IBM CS FEATURE
    IBM CS FEATURE
    SET ISOLATION C-UPDATE 0-EXECUTE OK
    SET RUNTIMESTAT-42X01
    SET STATISTICS -42X01
    VALUES 1- ROW(1)-EXECUTE OK