How to call the oracle function from java. Function returns number

Question

How should I call an Oracle function from Java? The function is supposed to return a number.

        CallableStatement cstmt = mJConn.prepareCall("{? = call fnd_request.submit_request( application => 'FND', program => 'JAVACONINSERT', description => 'CSV to DB Insert via Java' ,start_time => sysdate ,sub_request => FALSE, argument1 => '/home/TEST/java/t1.txt')}");
            cstmt.registerOutParameter(1, Types.INTEGER);
            cstmt.executeUpdate();
            int reqId = cstmt.getInt(1);
        System.out.println(reqId);

Are you trying to call an EBS function or a concurrent program? — Jacob
– Jacob, Commented Feb 13, 2019 at 17:56
plz give int reqId = cstmt.getInt(1); a try. (case sensitive!) — xerx593
– xerx593, Commented Feb 13, 2019 at 18:17
find_request is a PL/SQL package, yes? submit_request is a function in that package, yes? Note that a [PL/SQL] function is not the same as a [PL/SQL] procedure. — Abra
– Abra, Commented Feb 13, 2019 at 18:32

Tamara Koliada · Accepted Answer · 2019-02-14 19:37:20Z

1

Try replacing

String call = "{?= CALL Proc(?)}";

with

String call = "{CALL Proc(?, ?)}";

The former syntax is for calling a stored function, and the new one is for a stored procedure.

You can also to swap the order of the bind parameters :

cs.setString(1, "String");
cs.registerOutParameter(2, Types.INTEGER);

answered Feb 14, 2019 at 19:37

Tamara Koliada

1,2042 gold badges16 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to call the oracle function from java. Function returns number

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related