PostgreSQL 8.2.3 + ZStoredProc Error

DiegoBM · Post by **DiegoBM** » 09.03.2007, 10:52

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!

DiegoBM · Post by **DiegoBM** » 10.03.2007, 00:27

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.

Post by **mdaems** » 10.03.2007, 17:45

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

DiegoBM · Post by **DiegoBM** » 11.03.2007, 00:36

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!

jose fermin · Post by **jose fermin** » 21.04.2007, 18:11

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!!