Page 1 of 1

ZStroreProc

Posted: 20.04.2007, 19:49
by jose fermin
Hello everybody!!

I have a problem using zstoreproc and postgresql.

I made the following store procedure in PostgreSQL 8.2.3

CREATE OR REPLACE FUNCTION facturacion.sp_existencias(IN codigo integer, OUT valor numeric) AS
$BODY$

SELECT existencia_articulo
FROM articulo
WHERE codigo_articulo = $1;

$BODY$
LANGUAGE 'sql' VOLATILE;
ALTER FUNCTION facturacion.sp_existencias(IN codigo integer, OUT valor numeric) OWNER TO postgres;

When I put a ztoreproc on form and I open the component show this message :
"unsupported operation"

please, help me with this problem!!

I use: PostgreSQL 8.2.3, Zeoslib 6.6.1, windows xp

Posted: 23.04.2007, 09:43
by btrewern
ZStoredProc doesn't currently support PosgreSQL's functions. Use ZQuery instead.

Regards,

Ben