Search Postgresql Archives

Re: ADO adCmdStoredProc PlPgSql-SP Parameters

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Postgre.News.Firma@xxxxxxxxxxxxxxx wrote:

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" ?




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.

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux