Delphi 7 + ZEOS 6.6.4 + PostgreSQL 8 (stored procedures)

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
santigesualdo
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 01.02.2013, 13:38

Delphi 7 + ZEOS 6.6.4 + PostgreSQL 8 (stored procedures)

Post by santigesualdo »

Hi!! Im in my work migrating an application database from firebird to postgresql. This app have a lot of stored procedures that work just fine in firebird & zeos. So, when we clone the firebird db to postgresql the app cant use the stored procedure component of zeos with the message of "Unssuported operation"

The simple code of the procedure that im triyn to run is:

DECLARE
fechayhora TIMESTAMP;
BEGIN
fechayhora = current_timestamp;
return fechayhora;
END;

It works fine in the postgreSQL db manager, but in delphi with zeos it dont.

pd: sorry my english, i will appreciate any help.

Thanks for reading!
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

santigesualdo,

AFAIK there is no CallableStatment (an Zeos internal class) available for the 6.x series. Zeos7 supports the postgre stored procedures. Update?
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
Post Reply