Re: What is the precise syntax to call stored procedure?

Lee Fesperman wrote:
>
> Joseph Weinstein wrote:
> > Hi Jacob. The standard JDBC form for calling procedures is:
> >
> > Statement st = conn.prepareCall("{ CALL PROC1() }"); // note the () to denote zero params
> > st.execute();
>
> Interesting.
>
> My Java 2 (jdk 1.2.2) javadocs for java.sql.CallableStatement lists the syntax as
>
> {[?=] call <procedure-name> [ <arg1>,<arg2>,... ]}
>
> No parentheses at all!

You're absolutely right. My bad. Empty parentheses not needed. Joe

>
> --
> Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
> ================================================================================
> * Check out new website - Database Debunking (http://www.firstsql.com/dbdebunk/)
> * "The Forum Where Database Matters Are Set Straight"
 

-- 

PS: Folks: BEA WebLogic is in S.F., and now has some entry-level positions for
people who want to work with Java and E-Commerce infrastructure products. Send
resumes to joe_at_beasys.com
--------------------------------------------------------------------------------
                    The Weblogic Application Server from BEA                     
         JavaWorld Editor's Choice Award: Best Web Application Server
  Java Developer's Journal Editor's Choice Award: Best Web Application Server
     Crossroads A-List Award: Rapid Application Development Tools for Java     
Intelligent Enterprise RealWare: Best Application Using a Component Architecture
                 http://www.bea.com/press/awards_weblogic.html