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

[Gerd W. <ger...@t-...>]

Am 18.05.20 um 22:16 schrieb Marco Westermann:
> 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?

Usually you just need to pass parameters as you would in a plain SQL, 
for example:
{ call ProcName(1) }
or
{ call ProcName(1, 'Hello world') }


> 
> Also I was wondering how I can do an update an pass a parameter with
> ?
You can't.
Or to say it in the sense of the JDBC API: With SQuirreL you can't 
dynamically call java.sql.Connection.prepareStatement(...).

> 
> 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.
To me that's a strange behavior. Probably you should consult your 
database or JDBC driver vendor.

Gerd

> 
> 
> 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 )
> 
> 
> 
> 
> _______________________________________________ Squirrel-sql-users
> mailing list Squ...@li... 
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users