Oracle: using notational parameters which calling functions in insert statements are not allowed?

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?

+3
source share
1 answer

Because it was a feature added in 11g .

+9
source

Source: https://habr.com/ru/post/1742196/


All Articles