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(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Henry
Sent: Friday, February 22, 2002 5:00 PM
To: pgsql-jdbc(at)postgresql(dot)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