[Squirrel-sql-users] Call stored Procedure and update with params

[Marco W. <mw...@in...>]

Hi guys,

I am wondering how to call a stored procedure from squirrel sql editor.

With jdbc driver I use { call ProcName(?) } and pass the parameter to 
the statement.

Is there a way to do this in squirrel?

Also I was wondering how I can do an update an pass a parameter with ?

Cause I have the following problem. I want to update a table and insert 
some json. But if I provide the json in the set then afterwards the 
value is null:

update senddata set sed_ssendto = '{"type": "mail"}';

After running the command sed_ssendto is null. I have the same when I 
update the table with that command using jdbc / java.

But when I execute the statement with parameters like update senddata 
set sed_ssendto = ? and again pass the json as param it is working.


Thank you and best regards,

Marco


PS: When subscribing to this mailing list via: Squirrel homepage 
(http://squirrel-sql.sourceforge.net/) -> Click on Mailing Lists -> 
Click on Subscribe near squirrel-sql-users you never see the hole mail 
address where to send your questions to

( so the @lists.sourceforge.net part is never mentioned )