Parameter Order
From: <artmerar_at_yahoo.com>
Date: Mon, 4 Aug 2008 10:29:37 -0700 (PDT)
Message-ID: <eddc2e8e-3078-4cd2-8d4c-bd76ddfde3f1@8g2000hse.googlegroups.com>
Date: Mon, 4 Aug 2008 10:29:37 -0700 (PDT)
Message-ID: <eddc2e8e-3078-4cd2-8d4c-bd76ddfde3f1@8g2000hse.googlegroups.com>
This one is probably simple.......if I have a procedure where I pass a number of parameters, and some of those have default values, what if not all of the parameters have values?
Here:
PROCEDURE A (
P1 NUMBER,
P2 VARCHAR2,
P3 NUMBER DEFAULT 99,
P4 VARCHAR2 DEFAULT 'X') IS
Now, what if when PROCEDURE A is called, it only has P1, P2 &
P4......what gets passed for P3 since they are in a specific order,
NULL??
Received on Mon Aug 04 2008 - 12:29:37 CDT