PostgreSql RETURNS SETOF refcursor and UniStoredProc
Posted: Sun 11 Nov 2012 08:32
Good day! Starting with version 4.2.7 UniStoredProc does not open a stored procedure from PostgreSQL thet RETURNS SETOF refcursor
this code returns field "test_proc" is of unknown type,
In version 4.1.5 this error does not occur and I was able to get a cursor
with TDACursorField(UniStoredProc.Fields[0]).AsCursor;
Code: Select all
UniStoredProc := TUniStoredProc.Create(nil);
UniStoredProc.Connection := UniConnection;
UniStoredProc.StoredProcName := 'test_proc';
UniConnection.StartTransaction;
UniStoredProc.Open;
this code returns field "test_proc" is of unknown type,
In version 4.1.5 this error does not occur and I was able to get a cursor
with TDACursorField(UniStoredProc.Fields[0]).AsCursor;