Why does Oracle 10 R2 prevent using notational parameters when calling functions in insert statements?
In my application, I call the function in the insert statement. If the notational method of passing parameters is used, I get an errorORA-00907: Missing right parenthesis
INSERT INTO foo
(a,
b,
c)
VALUES (c,
F1(P1=>'1', P2=>'2', P3 => '3'),
e)
Changing this parameter to pass parameters based on the position, and the same code was compiled without errors.
INSERT INTO foo
(a,
b,
c)
VALUES (c,
F1('1','2','3'),
e)
Why is this so?
source
share