1 Reply Latest reply on Aug 7, 2006 2:15 PM by 525783

    procedure with OTYPE_REF, OTYPE_TABLE parameters


      I am trying to execute a procedure where parameters are Records:

      PL/SQL code:
      PROCEDURE get_customer(vio_customer_r IN OUT customer_rt , vo_status_r OUT status_rt);

      Defined as follow:
      TYPE status_rt IS RECORD (ok BOOLEAN, error_msg VARCHAR2(500));

      and I can't figure out which servertype to use in my ParamCollection or what the
      object_name argument should be in the Add method:

      C++ code:
      OParameter vio_customer_r = paramCollec.Add("vio_customer_r", 0,OPARAMETER_INOUTVAR, OTYPE_REF ); (??)

      Could anyone help me Please?