Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle: Use of notational parameters which calling functions in insert statements not allowed?

Why does Oracle 10 R2 not allow use of notational parameters while calling functions in insert statements ?

In my app, I'm calling a function in an insert statement. If use notational method of parameter passing, I get an ORA-00907: Missing right parenthesis error message

INSERT INTO foo
            (a,
             b,
             c)
VALUES      (c,
             F1(P1=>'1', P2=>'2', P3 => '3'),
             e)

Changing the same to position based parameter passing, and the same code gets compiled with no errors.

INSERT INTO foo
            (a,
             b,
             c)
VALUES      (c,
             F1('1','2','3'),
             e) 

Why is this so ?

like image 723
Sathyajith Bhat Avatar asked Dec 05 '25 21:12

Sathyajith Bhat


1 Answers

Because it was a feature added in 11g.

like image 144
Gary Myers Avatar answered Dec 07 '25 15:12

Gary Myers



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!