Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error 307 in Oracle Forms 6i

300230Jun 14 2007 — edited Jun 15 2007
Hi to All,
While compiling my form, I get this error.

add_parameter(pl_id,
'ENTITY_GRP_ID',
text_parameter,
to_char(:entity_grp.entity_grp_id));
Error 307 at line...
too many declarations of 'TO_CHAR' match this call

I modified the code as below and it compiled.

1. add_parameter(pl_id,
'ENTITY_GRP_ID',
text_parameter,
:entity_grp.entity_grp_id);

My question is the value parameter is varchar2 and :entity_grp.entity_grp_id is number, it even compiles with this code.

2. add_parameter(pl_id,
'ENTITY_GRP_ID',
text_parameter,
':entity_grp.entity_grp_id');

I have no way of testing this form as it is called from other forms and I do not have the previliege to run it.
Will this work in production? if so which one.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2007
Added on Jun 14 2007
2 comments
994 views