procedure.out

derby database source code.good for you.

         DROP SCHEMA SQL-38001
    CALLLING CONTAINS SQL
         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38002
         DROP VIEW SQLCO-38002
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         VALUES 1,2,3-38004
         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
         CREATE SCHEMA S-38002
         DROP SCHEMA SQL-38002
    CALLLING READS SQL DATA
         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38002
         DROP VIEW SQLCO-38002
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         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
    CALLLING MODIFIES SQL DATA
         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-UPDATE 0-EXECUTE OK
         DROP VIEW SQLCO-UPDATE 0-EXECUTE OK
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         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
CALL ** NO SQL
    CALLLING DEFAULT (MODIFIES SQL DATA)
         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38001
    CALLLING NO SQL
         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38001
    CALLLING CONTAINS SQL
         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38001
    CALLLING READS SQL DATA
         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38001
    CALLLING MODIFIES SQL DATA
         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38001
CALL ** CONTAINS SQL
    CALLLING DEFAULT (MODIFIES SQL DATA)
         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38002
    CALLLING NO SQL
         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38001
         DROP VIEW SQLCO-38001
         LOCK TABLE SQLC-38001
         VALUES 1,2,3-38001
         SET SCHEMA SQLC-38001
         CREATE SCHEMA S-38001
         DROP SCHEMA SQL-38001
    CALLLING CONTAINS SQL
         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38002
         DROP VIEW SQLCO-38002
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         VALUES 1,2,3-38004
         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
         CREATE SCHEMA S-38002
         DROP SCHEMA SQL-38002
    CALLLING READS SQL DATA
         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38004
    CALLLING MODIFIES SQL DATA
         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38002
CALL ** READS SQL DATA
    CALLLING DEFAULT (MODIFIES SQL DATA)
         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38002
    CALLLING NO SQL
         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38001
         DROP VIEW SQLCO-38001
         LOCK TABLE SQLC-38001
         VALUES 1,2,3-38001
         SET SCHEMA SQLC-38001
         CREATE SCHEMA S-38001
         DROP SCHEMA SQL-38001
    CALLLING CONTAINS SQL
         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38002
         DROP VIEW SQLCO-38002
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         VALUES 1,2,3-38004
         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
         CREATE SCHEMA S-38002
         DROP SCHEMA SQL-38002
    CALLLING READS SQL DATA
         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38002
         DROP VIEW SQLCO-38002
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         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
    CALLLING MODIFIES SQL DATA
         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
         STATE-38002
CALL ** MODIFIES SQL DATA
    CALLLING DEFAULT (MODIFIES SQL DATA)
         CALL SQLC.SQLCONTROL2_0 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-UPDATE 0-EXECUTE OK
         DROP VIEW SQLCO-UPDATE 0-EXECUTE OK
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         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
    CALLLING NO SQL
         CALL SQLC.SQLCONTROL2_1 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38001
         DROP VIEW SQLCO-38001
         LOCK TABLE SQLC-38001
         VALUES 1,2,3-38001
         SET SCHEMA SQLC-38001
         CREATE SCHEMA S-38001
         DROP SCHEMA SQL-38001
    CALLLING CONTAINS SQL
         CALL SQLC.SQLCONTROL2_2 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38002
         DROP VIEW SQLCO-38002
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         VALUES 1,2,3-38004
         SET SCHEMA SQLC-UPDATE 0-EXECUTE OK
         CREATE SCHEMA S-38002
         DROP SCHEMA SQL-38002
    CALLLING READS SQL DATA
         CALL SQLC.SQLCONTROL2_3 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-38002
         DROP VIEW SQLCO-38002
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         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
    CALLLING MODIFIES SQL DATA
         CALL SQLC.SQLCONTROL2_4 (?, ?, ?, ?, ?, ?, ?) 
         CREATE VIEW SQL-UPDATE 0-EXECUTE OK
         DROP VIEW SQLCO-UPDATE 0-EXECUTE OK
         LOCK TABLE SQLC-UPDATE 0-EXECUTE OK
         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
CALL SQLCONTROL3_0 (?, ?, ?, ?, ?, ?, ?)
EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
literals
DEFINED PROCEDURES FOR TY_%
  LITT.TY_BIGINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 BIGINT,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  LITT.TY_CHAR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 CHAR(10),OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  LITT.TY_DECIMAL AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 DECIMAL(5,2),OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  LITT.TY_DOUBLE AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 DOUBLE,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  LITT.TY_INTEGER AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 INTEGER,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  LITT.TY_REAL AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 REAL,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  LITT.TY_SMALLINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 SMALLINT,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
  LITT.TY_VARCHAR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 VARCHAR(10),OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
DATABASE METATDATA PROCEDURES FOR TY_%
  LITT.TY_BIGINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
    procedureColumnIn P1 BIGINT
    procedureColumnOut P2 VARCHAR
  LITT.TY_CHAR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
    procedureColumnIn P1 CHAR
    procedureColumnOut P2 VARCHAR
  LITT.TY_DECIMAL AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
    procedureColumnIn P1 DECIMAL
    procedureColumnOut P2 VARCHAR
  LITT.TY_DOUBLE AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
    procedureColumnIn P1 DOUBLE
    procedureColumnOut P2 VARCHAR
  LITT.TY_INTEGER AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
    procedureColumnIn P1 INTEGER
    procedureColumnOut P2 VARCHAR
  LITT.TY_REAL AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
    procedureColumnIn P1 REAL
    procedureColumnOut P2 VARCHAR
  LITT.TY_SMALLINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
    procedureColumnIn P1 SMALLINT
    procedureColumnOut P2 VARCHAR
  LITT.TY_VARCHAR AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest type procedureNoResult
    procedureColumnIn P1 VARCHAR
    procedureColumnOut P2 VARCHAR
-----
CALL LITT.TY_SMALLINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
CALL LITT.TY_INTEGER (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'.
CALL LITT.TY_BIGINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'long'.
CALL LITT.TY_REAL (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'float'.
CALL LITT.TY_DOUBLE (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
CALL LITT.TY_DECIMAL (null, ?)=>NULL<
CALL LITT.TY_CHAR (null, ?)=>NULL<
CALL LITT.TY_VARCHAR (null, ?)=>NULL<
CALL LITT.TY_SMALLINT (12, ?)=>12<
CALL LITT.TY_INTEGER (12, ?)=>12<
CALL LITT.TY_BIGINT (12, ?)=>12<
CALL LITT.TY_REAL (12, ?)=>12.0<
CALL LITT.TY_DOUBLE (12, ?)=>12.0<
CALL LITT.TY_DECIMAL (12, ?)=>12.00<
CALL LITT.TY_CHAR (12, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'INTEGER'. 
CALL LITT.TY_VARCHAR (12, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'INTEGER'. 
CALL LITT.TY_SMALLINT (23.43e1, ?)=>234<
CALL LITT.TY_INTEGER (23.43e1, ?)=>234<
CALL LITT.TY_BIGINT (23.43e1, ?)=>234<
CALL LITT.TY_REAL (23.43e1, ?)=>234.3<
CALL LITT.TY_DOUBLE (23.43e1, ?)=>234.3<
CALL LITT.TY_DECIMAL (23.43e1, ?)=>234.30<
CALL LITT.TY_CHAR (23.43e1, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DOUBLE'. 
CALL LITT.TY_VARCHAR (23.43e1, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DOUBLE'. 
CALL LITT.TY_SMALLINT (176.3, ?)=>176<
CALL LITT.TY_INTEGER (176.3, ?)=>176<
CALL LITT.TY_BIGINT (176.3, ?)=>176<
CALL LITT.TY_REAL (176.3, ?)=>176.3<
CALL LITT.TY_DOUBLE (176.3, ?)=>176.3<
CALL LITT.TY_DECIMAL (176.3, ?)=>176.30<
CALL LITT.TY_CHAR (176.3, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DECIMAL'. 
CALL LITT.TY_VARCHAR (176.3, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DECIMAL'. 
CALL LITT.TY_SMALLINT ('12.34', ?) (42821) Columns of type 'SMALLINT' cannot hold values of type 'CHAR'. 
CALL LITT.TY_INTEGER ('12.34', ?) (42821) Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
CALL LITT.TY_BIGINT ('12.34', ?) (42821) Columns of type 'BIGINT' cannot hold values of type 'CHAR'. 
CALL LITT.TY_REAL ('12.34', ?) (42821) Columns of type 'REAL' cannot hold values of type 'CHAR'. 
CALL LITT.TY_DOUBLE ('12.34', ?) (42821) Columns of type 'DOUBLE' cannot hold values of type 'CHAR'. 
CALL LITT.TY_DECIMAL ('12.34', ?) (42821) Columns of type 'DECIMAL' cannot hold values of type 'CHAR'. 
CALL LITT.TY_CHAR ('12.34', ?)=>12.34     <
CALL LITT.TY_VARCHAR ('12.34', ?)=>12.34<
JIRA-491 Successful.
JIRA-492 successful -- no hang!