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@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 - 09:52:39 CDT