Re: Internal Error 1407

Murali Kazhipurath wrote:
>
> Does anyonw known what Internal error 1407 means. We have an Oracle 7.3
> Server under Windows NT 3.51. We get this error while trying to execute
> large PL/SQL stored procedures. Following is the pattern:
>
> 1. Many times the stored procedure execution aborts with the internal error
> 1407.
> 2. Some times, it hangs. At this point, it looks like the connection is
> terminated. We cannot see the user session.
>
> The problem seem to have gone away when we explicitily dropped and
> recreated the procedure. (drop and create as opposed to create or replace).

  Would you mind to give specify the error type such as ORA or PLS?   

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841