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!

ORA-04062 Signature has been change

RaivisJul 27 2016 — edited Jul 28 2016

Hi,

Could you help me please. I am wondering about 2 things.
For example, i have defined 1 simple variable and other record variable in forms when-validate-item trigger.

DECLARE

v_variable TABLE.COLUMN%TYPE;

v_record   TABLE%ROWTYPE;

BEGIN

...

END;

If i modify this TABLE.COLUMN size from, example VARCHAR2(10) to VARCHAR2(50), and don't recompile form, can i get ORA-04062 error ?

And other case

If i add new column to TABLE and don't recompile form could i get the same ORA-04062 error ?

Also are the same cases applicable to oracle libraries ?

Thanks for any help in advance.

BR,
Raivis

This post has been answered by CarlosDLG on Jul 27 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2016
Added on Jul 27 2016
7 comments
2,483 views