DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006

    signature change error

    i have made some changes in my existing procedure.i am using Oracle forms 5.0. Form 'A' calls that procedure. but after modification, when i run that form from live environment, it gives me following error:

    " ORA-04062 (Signature has been changed) ".

    although same form is working fine if i run it from development environment.
    everything is working fine if i open & run the form from ORACLE FORM BUILDER.
    but as soon as i compile the form & run it from live Environment it gives me above mentioned error.

    Kindly solve it.
    Early action in this matter will be highly appreciated.


  2. #2
    Join Date
    Oct 2007
    You can do either of the following :

    1) recompile store procedure or (Thru SQL * Plus)
    2) restart form module second time.

    1) recompile store procedure or
    alter [procedure/function/package] strore_name compile;
    2) restart form module second time.
    -- steps of Oracle runform execution process
    -- 1. Oracle forms try to execute store procedure
    -- and compare timestamps forms and store procedure
    -- if store procedure was compiling later then form module
    -- then u get this message.
    -- 2. when u restart runform again whithout any
    -- addition action, usually all ok

  3. #3
    Join Date
    Feb 2006
    i tried that but it still gives me same error.
    will it do if i compile the procedure at remote server location rather than compiling it at my local client machine.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.