<div>
<div class="content wysiwyg-content">
Hi ,<br />
I have a Store Precodure wich takes a varchar input parameters .<br />
I am passing a String like &nbsp; '20' enquoted in the double quotes like this.<br />
exec sp_GetSearchedDeals @Country = &quot;&nbsp;'09' &quot;&nbsp;.<br />
This Statement works from the DB ( I am using Rapid SQL) . But in my java Program it gives a exception like this<br />
<br />
ERROR:com.sybase.jdbc2.jdb<wbr />c.SybSQLEx<wbr />ception: Invalid column name ''09''. <br />
I have to pass the single quotes in my String ( the varchar I am passing to the Store Procedure ) . How can i escape the single quotes inside the varchar data i am passing ?<br />
Any help will be greatly appreciated..<br />
Regards<br />
Deb
</div>
</div>


Hi ,
I have a Store Precodure wich takes a varchar input parameters .
I am passing a String like   '20' enquoted in the double quotes like this.
exec sp_GetSearchedDeals @Country = " '09' " .
This Statement works from the DB ( I am using Rapid SQL) . But in my java Program it gives a exception like this

ERROR:com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name ''09''. 
I have to pass the single quotes in my String ( the varchar I am passing to the Store Procedure ) . How can i escape the single quotes inside the varchar data i am passing ?
Any help will be greatly appreciated..
Regards
Deb

jdbc single quote problem ( how to escape)

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.