Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: SP call does not work

Re: SP call does not work

From: Bjorn Abelli <DoNotSpam.bjorn_abelli_at_hotmail.com>
Date: Sat, 22 May 2004 09:30:31 +0200
Message-ID: <2h8dsqFa0c3bU1@uni-berlin.de>

"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 (?, ?, ?, ?)}");


// Bjorn A Received on Sat May 22 2004 - 02:30:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US