DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ora-04062 frm-40735

  1. #1
    Join Date
    Mar 2002
    Posts
    10

    Arrow

    have a error ora-04062 and FRM-40735, devide to a package that contains parameteres type OUT.
    I think that the problem is the type of parameters because if i try with a database different instances is compiled the program, too i tried that there isn't problem with a oracle 8.1.6.
    I need help, please.
    Perphas there is a parched or similar for solution this type the problem.
    Thank very much in advange.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    U have "error" in timestamp of store procedure.
    U may:
    1) recompile store procedure or
    2) restart form module szecond time.

  3. #3
    Join Date
    Mar 2002
    Posts
    10

    Arrow

    Originally posted by Shestakov
    U have "error" in timestamp of store procedure.
    U may:
    1) recompile store procedure or
    2) restart form module szecond time.

    thanks Shestakov, but i don't know that meaning :
    restart form module szecond time. [/B][/QUOTE]
    because recompile all store procedure when there are a lot much ..., can I explain me how i make 2)
    thanks.

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by Shestakov

    1) recompile store procedure or
    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
    ---------------------------------------
    This is my experience.
    And it was with Oracle 7.2.3, 7.3.4.

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