You are not logged in.
- Topics: Active | Unanswered
#1 2014-11-19 10:12:10
- ed
- Member
- Registered: 2014-11-19
- Posts: 4
Use stored procedures in direct acces layer with the synDB.pas unit
We have an sql server we usually access with OLEDB. It is filled with business logic stored procedures returning datasets and return values. We would like to call this logic using synDB.pas direct access layer.
Is is possible to use parametrized stored procedures with returning datasets and return values using OLEDB and the synDB.pas unit?
Offline
#2 2014-11-19 10:45:58
Re: Use stored procedures in direct acces layer with the synDB.pas unit
It should work but was not fully tested yet.
My concern is about the returned datasets.
Cursors are implemented for SynDbOracle but not for OleDb yet.
Maybe you could help.
Offline
#3 2014-11-19 13:36:02
- ed
- Member
- Registered: 2014-11-19
- Posts: 4
Re: Use stored procedures in direct acces layer with the synDB.pas unit
I'll see if i can run some tests tonight.
Offline
#4 2014-11-23 10:55:28
- ed
- Member
- Registered: 2014-11-19
- Posts: 4
Re: Use stored procedures in direct acces layer with the synDB.pas unit
No luck, so far.
I can call the stored procedure fine. The resulting dataset just isn't returned.
It seems stored procedures in mssql don't return datasets the way queries do.
I'll look into the way TStoredProc does it on delphi, see if i can figure something out.
Offline
#5 2014-11-23 11:51:41
Re: Use stored procedures in direct acces layer with the synDB.pas unit
Yes, result sets output parameters are handled only by SynDBOracle by now.
I think you can take a look at SynDBOracle to see how it was implemented at SynDB level.
There are already methods to return cursors in the SynDB interfaces.
Any hint to include them in SynOleDB may be very appreciated.
Offline