Postgre.News.Firma@xxxxxxxxxxxxxxx wrote:
Which driver are you using? If it's the OLE DB provider, then there is a solution, provided that you modify your stored procedure a little. You can probably write a wrapper procedure, if that's not acceptable as it is.Hi,
How do I call a StoredProcdure, written in PlPqSql which returns a set of records (or tableWhatever)
and wants parameters,
from ADO while using "adCmdStoredProc" ?
If your function returns "refcursor", then OLE DB will interpret that to mean that the function has rowset returns, and will emulate the standard calls surrounding returning multiple results.
Please feel free to let me know if this solves your problem. Please CC me on replies.
Shachar
-- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
