Re: SP call does not work
From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Sat, 22 May 2004 07:52:39 -0700
Message-ID: <40AF6937.6020106_at_bea.com>
Date: Sat, 22 May 2004 07:52:39 -0700
Message-ID: <40AF6937.6020106_at_bea.com>
Bjorn Abelli wrote:
> "Joe Weinstein" wrote...
>
>
>>You missed one '(' in the SQL. It should be:
>>
>>CallableStatement cs =
>> con.prepareCall
>>("{call schtru.sp_get_all_descr ( ?, ?, ?, ?}");
>
>
> Shouldn't that actually be "two" misses?
> One in the end of the argument list as well... ;-)
>
> CallableStatement cs =
> con.prepareCall
> ("{call schtru.sp_get_all_descr (?, ?, ?, ?)}");
>
Yep.
>
> // Bjorn A
>
>
Received on Sat May 22 2004 - 16:52:39 CEST