AlexeySh
User
Fresh Boarder
| Posts: 2 |   |
Karma: 0
|
|
How to use TOCIStoredProc with TDataSetProvider (MIDAS)?
|
|
Posted: 2003/02/21 15:05 |
|
|
|
|
Hi,
I've tried to use TOCIStoredProc object with TDataSetProvider in my Remote DataModule.
The stored procedure has only 1 parameter - OUT REF CURSOR.
The problem is that when I activate ClientDataSet, which is attached to that DataSetProvider, I get an exception 'NOE11/VAR - Variable require prepared statement for operation'. I've found that this exception is raised when DSP tries to apply parameters from CDS to OCIStoredProc.
Is it possible anyway to use TOCIStoredProc (which returns a dataset from Oracle db) with MIDAS? If yes then how?
Thank you,
Alexey.
|
|
