[SQL] CallableStatement

- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 06, 2000 3:10 PM Subject: re : [SQL] CallableStatement : : what's your problem exactly ? : : Thomas, : : : : == : Posté par Shane McEneaney le 6/12. : : Hi, : can anybody tell me w

[SQL] CallableStatement

Hi, can anybody tell me where I can get a free JDBC driver for Postgresql that implements CallableStatement? The driver in the distribution I have is PostgreSQL 7.0.2. Thanks in advance, Shane

[SQL] ERROR: copyObject: don't know how to copy 611

I get the error ERROR: copyObject: don't know how to copy 611 when I try to run the following procedure. The create table is causing the problem. CREATE FUNCTION "my_func" (int8) RETURNS int8 AS ' declare v_my_var ALIAS FOR $1; begin create table my_table(my_id int); end; ' LANGUAGE 'p

[SQL] Return number of rows update in query

Hi, can anybody tell me how to capture the number of rows updated in an update query inside a stored procedure? This doesn't work but hopefully you will see what I mean. CREATE FUNCTION "test" () RETURNS int AS ' DECLARE v_number_of_rows int; BEGIN select into v_number_of_ro

[SQL] How to Return number of rows updated in stored procedure

Hi, can anybody tell me how to capture the number of rows updated in an update query inside a stored procedure? This doesn't work but hopefully you will see what I mean. CREATE FUNCTION "test" () RETURNS int AS ' DECLARE v_number_of_rows int; BEGIN select into v_number_of_ro