Results 1 to 8 of 8
  1. #1
    Join Date
    May 2006
    Posts
    46

    Unanswered: PL/SQL compilation error

    Hi Experts,

    While compiling one of my stored procedures, I am getting this peculiar error.

    PLS-00801: internal error [phdcsql_print_kge_errors:arm pos]


    Please help me to fix this.


    Thanks
    PS

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Without a procedure code, here you are:
    Quote Originally Posted by Oracle
    PLS-00801: internal error [string]

    Cause: This is a generic internal error that might occur during compilation or execution. The first parameter is the internal error number.

    Action: Report this error as a bug to your Customer Support representative.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Can you debug code you can not see?
    (I doubt it because it appears you can not debug code you can see.)
    Most folks can't.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    May 2006
    Posts
    46
    I don't see any error in the code as such. I walked thru' the code of 1000 lines, but no error. Even if there is any error, that would be the compilation errors where we can fix it.

    But this is totally an irrelevant error.

    Please help.

    Thanks
    PS

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I don't see any error in the code as such.
    I don't see any error either.

    >But this is totally an irrelevant error.
    Then ignore it.

    >Please help.
    We can't help you because we don't know what you are doing or doing wrong.

    We don't even know Operating System name or version or Oracle version (to 4 decimal places).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jun 2010
    Posts
    2

    Smile How I resolved a similar issue

    Hello folks: When I encountered a similar issue I padded the table names with fully qualified table names (ie, schemaname.table_name) it compiled fine without any errors.

    Hope this is helpful.

    ~ NRIGirl

  7. #7
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    NRIGirl,

    you got an ORA-600 when not qualifying the tablename ????????

    Is Oracle Version 4 still around ?
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  8. #8
    Join Date
    Jun 2010
    Posts
    2

    This is in reference to the PLS-00801 error

    PLS-00801: internal error [phdcsql_print_kge_errorsarm pos]

    When I qualified the table names, my stored procedure compiled fine. We are using Oracle 10G.

    ~ NRIGirl

Posting Permissions

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