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

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

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

Postby santigesualdo » 26.02.2013, 13:43

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 Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 28.02.2013, 21:54

santigesualdo,

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

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

Image


Return to “6.6 - stable”

Who is online

Users browsing this forum: No registered users and 1 guest