Page 1 of 1

PostgreSQL 8.2.3 + ZStoredProc Error

Posted: 09.03.2007, 10:52
by DiegoBM
Hello,

I'm trying to insert a simple row through a ZStoredProc component but on executing I always get "Unsupported operation" error no matter what I try.

What should I do?

Thanks!

Posted: 10.03.2007, 00:27
by DiegoBM
I forgot to say that I'm currently using Delphi 7. The problem seems to be on dbc, cause many functions seems to raise a Unsupported operation exception no matter what. But many people on MySql seems to be using stored procs, so I'm confused.

Any light on this matter pleaseee?

Regards.

Posted: 10.03.2007, 17:45
by mdaems
Hi Diego,

What database are you tabling about Mysql or PostgreSQL? (You're in postgre forum)
For mysql ZStoredProc is not implemented yet, but there are workarounds, just check the forums here. (there's a search function)
For PostGreSQL I'm not 100% sure, but I'm afraid it's not implemented either. No ideas about workarounds there.

Mark

Posted: 11.03.2007, 00:36
by DiegoBM
I do use postgresql. That's what I thought, seems not to be implemented yet.

Thank you anyway, I can still use plain ZQuery ^^

Regards!

Posted: 21.04.2007, 18:11
by jose fermin
Hola Diego!!

Soy dominicano y quisiera saber si resolviste el problema d los procedimientos almacenados hechos en postgresql y usados mediante un zstoreproc. A mi me da el mismo problema q a ti.

Ojala podamos resolver ese problema!!