Oracle: Use of notational parameters which calling functions in insert statements not allowed ?
Posted
by Sathya
on Stack Overflow
See other posts from Stack Overflow
or by Sathya
Published on 2010-04-22T00:03:04Z
Indexed on
2010/04/22
1:43 UTC
Read the original article
Hit count: 290
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 ?
© Stack Overflow or respective owner
