0 Replies Latest reply on Jul 8, 2003 9:42 AM by 398510

    How can I get parameter name?

    398510
      ODatabase odb("test", "scott", "tiger");
      OParameterCollection params = odb.GetParameters();

      -------> and next how can I get parameter name?
      I hope get stored procedure parameter names and settiing parameter Add just like below.
      Plz tell me how can I get parameter name?
      I'm Korean, and my english is poor. sorry : )


      // add a parameter named 'DEPTNO'
      params.Add("DEPTNO", 20, OPARAMETER_INVAR, OTYPE_NUMBER);
                
      // add a parameter named 'EMPCURSOR'
      params.Add("EMPCURSOR", "", OPARAMETER_OUTVAR, OTYPE_CURSOR);
                
      //Execute the SQL statement
      odb.ExecuteSQL("BEGIN Employee.GetEmpData (:DEPTNO, :EMPCURSOR); END;");