2 Replies Latest reply on Sep 30, 2005 1:16 PM by 82532

    Using a PL/SQL stored procedure which returns a ref cursor

    456813
      Hi
      I have a table where one of its columns is based on a varray type(the varray type is simply made up of 575 varchars each of length 3075)
      My PL/SQL stored procedure would return a ref cursor of records from this table containing the varray column to the calling VB application.

      Is this possible in VB using OO4O code?

      Can anyone pls provide a sample VB code using OO4O which can make use of the above stored procedure and process the recordset returned by the ref cursor of SP.

      Thanks in advance