Originally posted by: Zhouwei

I was just wondering if it is possible to read (DBRead) from an Oracle stored procedure returning one or more cursors into a Cplex tuple set. I am able to execute stored procedures which do not return a result set (DBExecute), but I have not been able to read using a stored procedure so far. Any help would be greatly appreciated.
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

Did you check the following technote: Calling a stored DB procedure in OPL ?
It is possible to initialize a set calling a stored procedure but I don't think Oracle cursors are supported.
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: Zhouwei

Yes, I did follow the examples in the link.

I was able to execute stored procedures which do not return a result set. However, I have not had any success with stored procedures returning a result set.
#DecisionOptimization
#OPLusingCPLEXOptimizer