Re: set parameter not enabled?

Henry,

Postgres does not natively support a stored procedure the way that
others do. There is a patch in the pipe which attempts to convert a
Callable statement into a postgres "stored proc", but I'm not sure it
will work.

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Henry
Sent: Friday, February 22, 2002 5:00 PM
To: pgsql-jdbc@postgresql.org
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