Exception is : java.sql.SQLSyntaxErrorException: ORA-00936: missing expression -

Exception is : java.sql.SQLSyntaxErrorException: ORA-00936: missing expression -

select info sql database through java code.

string sql="select [irb#] irb_number, [refnum] study_pk cyberprotocol1 velosrequestid = '"+currentrequest+"' , transcationstatus = 1"; resultset resultset=executequery(sql); public resultset executequery(string sqlstring) { logdebuginfo("in executequery() function",log_type_informative); resultset sqlresultset = null; seek { logdebuginfo("sqlstring:: " + sqlstring,log_type_critical); executestatement=gconn.preparestatement(sqlstring); sqlresultset=executestatement.executequery(); homecoming sqlresultset; } grab (exception errorexception) { processexception(errorexception, false); } homecoming sqlresultset; }

and exception : java.sql.sqlsyntaxerrorexception: ora-00936: missing expression

java sql sql-server