text: -- @testpoint: 测试仅带出参，出参类型为INT的存储过程
  
  
  drop table if exists TEST_001;
  CREATE TABLE TEST_001(
    T1 INT,
    T2 INTEGER NOT NULL,
    T3 BIGINT,
    T4 NUMBER DEFAULT 0.2332,
    T5 NUMBER(12,2),
    T6 NUMBER(12,6),
    T7 BINARY_DOUBLE,
    T8 DECIMAL,
    T9 DECIMAL(8,2),
    T10 DECIMAL(8,4),
    T11 REAL,
    T12 CHAR(4000),
    T13 CHAR(100),
    T14 VARCHAR(4000),
    T15 VARCHAR(100),
    T16 VARCHAR2(4000),
    T17 NUMERIC,
  
    T19 DATE,
    T20 TIMESTAMP,
    T21 TIMESTAMP(6),
    T22 BOOL
  ) ;
  
  create unique index  indx_out_param_t1 on TEST_001(T1);
  create index indx_out_param_t2 on TEST_001(T2,T17,T20);
  
  INSERT INTO TEST_001 VALUES(12,58812,546223079,1234567.89,12345.6789,12.3456789,1234.56,2345.67,12345.6789,12.3456789,12.33,'dbcd','abcde','1999-01-01','ab','adc',123.45,'2005-08-08','2000-01-01 15:12:21.11','2000-08-01 15:12:21.32',true);
  INSERT INTO TEST_001 VALUES(13,58813,546223078,1234567.78,12345.5678,12.2345678,1234.67,2345.78,12345.5678,12.2345678,12.44,'dbce','abcdf','abcdeg','ac','ade',123.46,'2012-08-08','2000-02-01 15:22:21.11','2012-02-01 15:12:11.32',false);
  INSERT INTO TEST_001 VALUES(14,58814,546223077,1234567.67,12345.4567,12.1234567,1234.78,2345.89,12345.4567,12.1234567,12.55,'dbcf','abcdg','2010-02-28','ad','adf',123.47,'2002-08-11','2000-03-01 15:42:21.11','2008-08-12 15:13:21.32',true);
  INSERT INTO TEST_001 VALUES(15,58814,546223077,1234567.67,12345.4567,12.1234567,1234.78,2345.89,12345.4567,12.1234567,12.55,'dbcf','abcdg','abcdeh','ad','adf',123.47,'2002-08-11','2000-03-01 15:42:21.11','2008-08-12 15:13:21.32',true);
  INSERT INTO TEST_001 VALUES(16,58814,546223077,1234567.67,12345.4567,12.1234567,1234.78,2345.89,12345.4567,12.1234567,12.55,'dbcf','abcdg','abcdeh','ad','adf',123.47,'2002-08-11','2000-03-01 15:42:21.11','2008-08-12 15:13:21.32',true);
  
  
  
  
  
  --仅带出参的存储过程测试（测试出参类型为INT的存储过程）
  CREATE OR REPLACE PROCEDURE PROC_OUT_PARAM_001(P1 OUT INT)
  AS
  BEGIN
  SELECT T1 INTO P1 FROM TEST_001 WHERE T2=58812;
  raise info ':%',P1;
  EXCEPTION
  WHEN NO_DATA_FOUND THEN raise info 'NO_DATA_FOUND';
  END;
  /
  
  --调用存储过程
  DECLARE
  V_P1 INT;
  BEGIN
  PROC_OUT_PARAM_001(V_P1);
  END;
  /
  drop PROCEDURE PROC_OUT_PARAM_001;
  drop table if exists test_001;