Plz do abide to our Terms & Condition:

    • Do not paste URL Links directly in any content instead post them as Hyperlink inside a text.
       
    • To post a Link directly use instead Bookmark.
       
    • If we find anyone posting beyond the warning we will immediately terminate your account without any warning. 

ORA-06512 : at line

    Meril Jeffery John.J
    • 159 views
    • 0/5 (0 votes)
    Asked by Meril Jeffery John.J Answers (1)

    ORA-06512: it indiacates a trigger and the line of number the error is but still i cant get i have just declared a local_amount number(2)

    Answers (1)

      • Arun prasad
        By Arun prasad

        Cause: Backtrace message as the stack is unwound by unhandled exceptions.

        ORA-06512 is simply a series of related messages issued at different levels of Oracle. in which the message directly preceding ORA-06512 will list the reason for the error.

        The ORA-06512 error itself does not indicate the actual error. It normally indicates the line number at which the oracle PL/SQL code has caused an error. There will be another main error occurred in your process and that error happened in the line number as mentioned in ORA-06512 message description.

        Example:

        declare
        myname varchar2(5);
        begin
        myname := 'Nimish Garg';
        end;
        /
        ERROR at line 1:
        ORA-06502: PL/SQL: numeric or value error: character string buffer too small
        ORA-06512: at line 4

        Here the main error is "character string buffer too small" for the variable "myname"and it can be corrected by increasing the size of "myname"

        Solution:

        declare
        myname varchar2(20);
        begin
        myname := 'Nimish Garg';
        end;