Re: Argument order in a Procedure - Oracle8

I think this should work

CREATE or REPLACE PROCEDURE test (

p_arg1 IN X.X%TYPE,
p_arg2 IN X.Y%TYPE,
p_arg3 IN X.Z%TYPE) AS

EXECUTE test(p_arg1=>arg1, p_arg2=>arg2, p_arg3=>arg3)

Hope this helps.
Bart.

Cheech wrote in message <8b73or$r8q$1_at_geraldo.cc.utexas.edu>...
>When I create a procedure like this:
>CREATE or REPLACE PROCEDURE test (
>arg1 IN X.X%TYPE,
>arg2 IN X.Y%TYPE,
>arg3 IN X.Z%TYPE) AS
>...
>I can only get it to work by passing the arguments in reverse order:
>EXECUTE test(arg3, arg2, arg1)
>
>arg1 is VARCHAR2(6)
>arg2 is VARCHAR2(4)
>arg3 is NUMBER(8,4)
>
>I have to execute three procedures this way. My other procedures work
>normally and accept the args in the order specified in the code. From what
>I understand Oracle matches arguments by datatype not the variable name. I
>recreate my procedures often and Oracle speratically changes the arg order.
>Is there any way around this?
>
>
>
>
Received on Fri Mar 24 2000 - 04:32:00 CST