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

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!

--
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"