SQLSyntaxErrorException: ORA-00900: invalid SQL statement running sql function from jdbc

Question

I have below java code:

void insertRatings(String Rname , String uName ,BigDecimal rating , String rDate) throws SQLException, ParseException
    {
        CallableStatement cs = conn.prepareCall("? = call insertRating(?,?,?,?) ");

        cs.registerOutParameter(1, Types.INTEGER);
        cs.setString(2, Rname);
        cs.setString(3, uName);
        cs.setBigDecimal(4, rating);
        cs.setDate(5,new Date(new SimpleDateFormat("dd/MM/yyyy").parse(rDate).getTime()));


        cs.executeQuery();

        System.out.println("Output recived from fucntion :: "+cs.getInt(1));

    }

And SQL function is:

create or replace function insertRating(Rname varchar2(100),uName varchar2(100),rating Number,
rDate Date) return Integer is

The SQL function works as expected. However, when I run the java code I get the below error for cs.executeQuery();

Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement

What did I miss?

Why not take a look at the documentation?

miracle173
– miracle173

2018-02-04 17:42:37 +00:00
Commented Feb 4, 2018 at 17:42 — miracle173
– miracle173, Commented Feb 4, 2018 at 17:42

Mark Rotteveel · Accepted Answer · 2018-02-04 10:37:34Z

2

I got the solution:

CallableStatement cs = conn.prepareCall(" { ? = call insertRating(?,?,?,?) }");

'{}' is what I was missing.

I hope it will someone.

edited Feb 4, 2018 at 10:37

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Feb 4, 2018 at 6:07

Ravi Sharma

911 silver badge9 bronze badges

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

Collectives™ on Stack Overflow

SQLSyntaxErrorException: ORA-00900: invalid SQL statement running sql function from jdbc

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