mORMot Open Source

bagusprasojo

Member

Registered: 2016-07-26

Posts: 18

PostgresSQL : DECLARE CURSOR can only be used in transaction blocks

Hi ,

Sometimes (not always) I get error

 [FireDAC][Phys][PG][libpq] ERROR: DECLARE CURSOR can only be used in transaction blocks 

. After executing Add / AddOrUpdate of TSQLHttpClient , then i execute "select query" and get the above error.

here is my logs :

SynDBFireDAC.TSQLDBFireDACStatement(02F19110) select ID,AccountAccDep,Category,Company,DateCreated,AIN,AssetStatus,AssetType,Nama,AccountAssetAP,Address,Description,Employee,Entity,Ownership,Parent,SN from public.Asset where ID=5
20160822 02012829  B EXC   	EPgNativeException ("[FireDAC][Phys][PG][libpq] ERROR: DECLARE CURSOR can only be used in transaction blocks") at 00712D13  stack trace API 00539786 

I get this error when using PostgresSQL, but get no error when using Ms SQL Server.
Has any body found workwround of this error ?

Last edited by bagusprasojo (2016-08-22 02:32:45)