Missing right quote in callableStatement.getString result

Question

I am calling an Oracle stored procedure from spring boot application. The SP will return either Y or N (status). It is working perfectly in SQL Navigator. But when i call it from Java I am getting the status as "Y (i.e. with an opening quote and no closing quote)

callableStatement.registerOutParameter("isavailableflag", OracleTypes.CHAR);
String isUserExists = callableStatement.getString("isavailableflag");

isUserExists = "Y

How to resolve this issue? For now, I am handling from Java but I am looking for a cleaner solution.

Stored Procedure

PROCEDURE isusernameavailable (applicationname IN VARCHAR2,
username IN VARCHAR2                                           
isavailableflag OUT CHAR)
.
.
.

Try changing **OracleTypes.CHAR** to **OracleTypes.VARCHAR** — Venu Duggireddy, Mar 13 '18 at 23:33
Even after changing it to OracleTypes.VARCHAR, I didn't find any difference. Still getting "Y — Thiagarajan Ramanathan, Mar 14 '18 at 05:30
Can you try String.valueOf(callableStatement.getString("isavailableflag").charAt(0)) — Venu Duggireddy, Mar 14 '18 at 14:31
It worked perfectly. If you provide your solution in answer, I will mark that as the correct answer and upvote it. Thank you. — Thiagarajan Ramanathan, Mar 14 '18 at 17:32

score 1 · Accepted Answer · answered Mar 14 '18 at 19:42

1

Read the CHAR and convert it to String

callableStatement.registerOutParameter("isavailableflag", OracleTypes.CHAR);
String isUserExists = String.valueOf(callableStatement.getString("isavailableflag").charAt(0));

answered Mar 14 '18 at 19:42

Venu Duggireddy

786
6
9

Missing right quote in callableStatement.getString result

1 Answers1