英文:
Execute stored function without knowing registerOutParameter In JAVA
问题
CallableStatement cstmt = connection.prepareCall("{call ?:= MyFunctionName('value1','value2')}");
cstmt.registerOutParameter(1, OracleTypes.?); // 这里
cstmt.execute();
演示存储函数：
CREATE OR REPLACE FUNCTION IDK.MyFunctionName(param1 VARCHAR2, param2 VARCHAR2)
RETURN NUMBER
AS
V_FLAG NUMBER;
BEGIN
V_FLAG := 5;
RETURN V_FLAG;
END;
英文:
I'm calling a stored function but i don't know the return type of the function. It can be NUMBER,VARCHAR,CURSOR or DATE. so I don't know the registerOutParameter() type. help me out to resolve the problem
CallableStatement cstmt = connection.prepareCall("{call ?:= MyFunctionName('value1','value2')}");
cstmt.registerOutParameter(1, OracleTypes.?); // here
cstmt.execute();
Demo stored-function :
CREATE OR REPLACE FUNCTION IDK.MyFunctionName(param1 VARCHAR2, param2 VARCHAR2)
RETURN NUMBER
AS
V_FLAG NUMBER;
BEGIN
V_FLAG := 5;
RETURN V_FLAG;
END;
专注分享java语言的经验与见解，让所有开发者获益！
评论