ZStroreProc
Posted: 20.04.2007, 19:49
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
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