ZStroreProc

[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

[btrewern]

ZStoredProc doesn't currently support PosgreSQL's functions. Use ZQuery instead.

Regards,

Ben