Re: SP call does not work

"Joe Weinstein" <joeNOSPAM_at_bea.com> wrote in message news: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.
>

Are these opening/closing parentheses required by Oracle? I never use them with SQL Server. A review of the CallableStatement interface docs gives no indication that the parentheses are needed.

• Virgil