form builder doesnt show compilation errors but unix server does. [message #393882] |
Tue, 24 March 2009 15:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nastyjillu
Messages: 211 Registered: February 2009
|
Senior Member |
|
|
hi all,
i got a strange problem .
form builder doesn't show compilation errors but when i compile in unix server it is not creating .fmx and says compilation errors have occured.
error is given below:
error 306 at line 21,column 5
wrong number or types of arguments in call to 'PRC' .
pl/sql error 0 at line 21, column 5
statement ignored
i have checked that procedure, but its not at all wrong. i checked every field used by procedure, checked datatype of all fields used by procedure. checked number of arguments passed.
everything is perfect.
if at all there is any mistake in datatype or number of arguments, then form builder would have shown errors. but its not doing so.
then what might be the problem???
|
|
|
Re: form builder doesnt show compilation errors but unix server does. [message #393887 is a reply to message #393882] |
Tue, 24 March 2009 15:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nastyjillu
Messages: 211 Registered: February 2009
|
Senior Member |
|
|
forgot to tell,
block which calls this procedure is 'WMREV' and its an inherited block.
this procedure is being called in post-query trigger of 'WMREV' block.
to test the form, i made post-query trigger as NULL and commented original code and compiled the form in unix. now its not showing error.
what might be the problem when everything is correct??
|
|
|
|
|
|