Re: Stored procedures, ADO and VB 6.0 ....again ....HELP !!

If one of the parameters is IN OUT, then you can't pass a hard-coded value or constant as this parameter. The procedure will need you to use a variable for this parameter so it can return a value to the variable.

Try something like this instead: (I'm not familiar with the personnel.get_employees procedure, so this may need some tweaking.)

<<Test_Get_Employees>>
DECLARE    Some_Var_V NUMBER(3);

BEGIN    Some_Var_V := 5;

   Personnel.Get_Employees

         (20,
          15,
          Some_Var_V);

   Dbms_Output.Put_Line('Results of call to Get_Employees: '
                         || TO_CHAR(Some_Var_V));

END Test_Get_Employees;

Hope that helps -

James

"Jørgen Haukland" wrote:
>
> When I try f.ex:
> SQL> execute personnel.get_employees (20, 15, 5)
>
> I get this:
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to 'GET_EMPLOYEES'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> The procedure has 2 IN parameters and one IN OUT parameter. What am I doing
> wrong ?
>
Received on Wed Dec 09 1998 - 00:00:00 CST