|
From: Gerd W. <ger...@t-...> - 2020-05-20 23:43:41
|
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
|
