Re: set parameter not enabled?

Henry,
postgresql do support stored procedures.
You just can´t call them with CallableStatement in the jdbc interface.
You should use Statement or PreparedStatement.
There has been discussions on this list earlier. See the archives
Also, look at http://lab.applinet.nl./postgresql-jdbc/

Regards,
Per-Olof Norén

----- Original Message -----
From: "Henry" <hxzhang@cs.ualberta.ca>
To: <pgsql-jdbc@postgresql.org>
Sent: Friday, February 22, 2002 11:00 PM
Subject: [JDBC] set parameter not enabled?


> I got the following from a jdbc call:
> Exception: Callable Statements are not supported at this time.
>
> this exception comes out from a third party pure java report engine, thus
> the detailed information is not very much clear to me. When I was using
> Oracle as database backend, this exception is not there. however, when I
> change to postgres's  pgjdbc2.jar  JDBC driver, this exception raises.
Does
> that mean Postgres doesn't support stored procesure?

>
> thanks a lot!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>