PostgreSql RETURNS SETOF refcursor and UniStoredProc

[zeroandr]

Good day! Starting with version 4.2.7 UniStoredProc does not open a stored procedure from PostgreSQL thet RETURNS SETOF refcursor

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;

[ZEuS]

Thank you for the information. We have fixed the error with SETOF REFCURSOR procedure parameters, and will include the fix in the next UniDAC build.