signature change error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: signature change error

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    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.

    regards

  2. #2
    Join Date
    Oct 2007
    Posts
    7
    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
    Posts
    86
    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.


    regards

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