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

Question

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 ?

Gary Myers · Accepted Answer · 2010-04-22 02:26:08Z

9

Because it was a feature added in 11g.

answered Apr 22, 2010 at 2:26

Gary Myers

35.5k4 gold badges52 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

APC Over a year ago

Before then the => was only allowed when calling PL/SQL programs from other PL/SQL programs.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related