getting this error when trying to s

[extempore]

getting this error when trying to send 3 arguments while calling the procedure in sybase -com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near '@p0'

getting this while removing the arguments and sending nothing...the sybase procedure has the hard coded arguements now - com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near ')'.

can anyone tell me what the problems is? thanks.

Extempore

 

[wushutwist]

Show us the code. Wushutwist

 

[pipk]

you are probably missing a comma or apostrophe from your SQL, but we can't tell until you show us the statment causing the error.

 

[extempore]

Here is the code:

CallableStatement sp = connection.prepareCall("{ CALL p_vos_ repair_followup() }"

sp.execute();

throws
com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near ')'

*****************************************************
CallableStatement sp = connection.prepareCall("{ CALL p_vos_ repair_followup(?,?,?) }"

sp.setString(1, "EU-R223"
sp.setString(2, "EU-223"
sp.setString(3, "EU"

sp.execute();


throws

com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near '@p0'


either way i get the error.

 

[LeonTang]

Seems alright to me except that for callablestatements, we normally use executeUpdate() or executeQuery(), but then I guess it won't make much of a difference...

Are you 100% sure this is the part of the coding that is causing the problem?

 

[extempore]

Yeah positive...this is the place where the problem occurs...rest of the other procedures work perfectly and i dont have a clue whats with this one...i have seen the same error posted by another guy but apparently he did not get a response either...his posting is in the deja.com link :

http://groups.google.com/groups?q=c...3C0072F17485256AA2.0072F19085256AA2@webforums

Thanks