From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: modification required to pass Sun's CTS |
Date: | 2005-06-02 01:34:00 |
Message-ID: | 429E6208.4040001@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Dave Cramer wrote:
> cstmt = conn.prepareCall("{call Numeric_Proc
> (?,?,?)}");
>
> msg.setMsg("Register the output parameter");
> cstmt.registerOutParameter
> (1,java.sql.Types.NUMERIC,15);
> cstmt.registerOutParameter
> (2,java.sql.Types.NUMERIC,15);
> cstmt.registerOutParameter
> (3,java.sql.Types.NUMERIC,15);
>
> msg.setMsg("execute the procedure");
> cstmt.executeUpdate();
Ok, so that is exactly the case I was talking about, a procedure that
doesn't return a value or resultset, but has OUT parameters. We should
mask the resultset we get from the backend in this case as it's just an
implementation detail of our OUT mechanism. (i.e. executeUpdate() does
not complain, executeQuery() does complain, etc)
-O
From | Date | Subject | |
---|---|---|---|
Next Message | Giuseppe Sacco | 2005-06-02 04:54:04 | italian translation |
Previous Message | Dave Cramer | 2005-06-02 00:37:57 | Re: modification required to pass Sun's CTS |