怎样的到存储过程里的变量

[xinfudepangbian]

怎样的到存储过程里的变量

[xinfudepangbian]

CREATE OR REPLACE PROCEDURE "TMSP_TM_LINE_BASE_INSERT" (
X_LINE_NO IN VARCHAR,
X_FILA_NO IN NUMBER,
X_GROUP_NO IN NUMBER,
X_LINE_NAME IN VARCHAR,
X_LINE_TYPE IN NUMBER,
X_LINE_LENGTH IN NUMBER,
X_IS_UP_DOWN IN NUMBER,
X_STATION_SUM IN NUMBER,
X_VELOCITY_AVG IN NUMBER,
X_STATION_FIRST IN NUMBER,
X_STATION_LAST IN NUMBER,
X_START_TIME IN NUMBER,
X_END_TIME IN NUMBER,
X_SCHEDULE_TIME IN NUMBER,

RESULT OUT NUMBER, 就是这两个RESULT RETURN_ERR
RETURN_ERR OUT VARCHAR2)
IS
NUM INT;
BEGIN
RESULT:=0;
RETURN_ERR:=9000;
SELECT COUNT(*) INTO NUM
FROM TM_LINE_BASE_INFO
WHERE LINE_NO=X_LINE_NO;
IF NUM>0 THEN
RESULT:=1;
RETURN;
END IF;

INSERT INTO TM_LINE_BASE_INFO
(LINE_NO,FILA_NO,GROUP_NO,LINE_NAME,LINE_TYPE,LINE_LENGTH,IS_UP_DOWN,STATION_SUM,VELOCITY_AVG,
STATION_FIRST,STATION_LAST, START_TIME,END_TIME,SCHEDULE_TIME)
VALUES(X_LINE_NO,X_FILA_NO,X_GROUP_NO,X_LINE_NAME,X_LINE_TYPE,X_LINE_LENGTH,X_IS_UP_DOWN,X_STATION_SUM,X_VELOCITY_AVG,
X_STATION_FIRST,X_STATION_LAST,X_START_TIME,X_END_TIME,X_SCHEDULE_TIME);

EXCEPTION
WHEN OTHERS THEN
RETURN_ERR:=9001;
END;



就是这两个RESULT RETURN_ERR

[lip009]

try {
java.sql.Connection con = null;
con=...//取得数据库连接
//几个参数几个问号，包括输入和输出参数，假设第一个是输入参数（类型数字），第二个是输出参数（类型VARCHAR）
java.sql.CallableStatement call = con.prepareCall("{call 存储过程名(?,?)}");
//给第一个输入参数赋值
call.setLong(1, 1000);
//注册第二个输出参数类型
call.registerOutParameter(2, java.sql.Types.VARCHAR);
//执行存储过程
call.execute();
//取得输出参数
String param2 = call.getString(2);
}
catch (SQLException ex) {
ex.printStackTrace();
}

[xinfudepangbian]

谢谢了 可是小弟还是不太懂

[lip009]

写的那么明白的注释还看不懂,晕了!

[xinfudepangbian]

昨天晚上回去看了看 谢谢了