Topic
  • 2 replies
  • Latest Post - ‏2012-03-13T23:17:06Z by Zhouwei
Zhouwei
Zhouwei
4 Posts

Pinned topic Oracle SP

‏2012-03-10T05:57:03Z |
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.
Updated on 2012-03-13T23:17:06Z at 2012-03-13T23:17:06Z by Zhouwei
  • SystemAdmin
    SystemAdmin
    1883 Posts

    Re: Oracle SP

    ‏2012-03-12T17:45:55Z  
    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.
  • Zhouwei
    Zhouwei
    4 Posts

    Re: Oracle SP

    ‏2012-03-13T23:17:06Z  
    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.
    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.