Pass OUT parameters in procedure 1

[geerae]

I have a procedure for oracle 8.1.x where only one parameter is required (p_object). Using TOAD as an SQL editor I have verified the procedure works but when I call the procedure using:

exec rigppm_test('0000002')

I get the following error:

PLS-000306:wrong number or type of arguments in call to 'rigppm_test'

The procedure header is listed below,

CREATE OR REPLACE PROCEDURE rigppm_test (
p_object IN OUT VARCHAR2,
p_daystojob OUT NUMBER,
p_hourstojob OUT NUMBER,
p_ppmtype OUT VARCHAR2,
p_date OUT DATE,
p_util OUT NUMBER
)
IS
variable1;
variable2;
cursor c1
is
select blah blah;
BEGIN


Thanks for any suggestions or help,

Geerae

 

[karluk]

You can't pass a literal like '0000002' as an IN OUT parameter. It's impossible to change the value of a literal, so it can't be an out parameter.