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

Thread: Error occurred at recursive SQL level

  1. #1
    Join Date
    May 2002
    Posts
    1
    The following errors are reported by Oracle server during
    execution of our Telecom billing product which is based
    on Oracle 8.1.7 .

    1. ORA-07445 : exeception encountered:core dump [10]
    [4211044472][176][0]
    2. ORA-00604 : error occurred at recursive SQL level 1
    3. ORA-00911 : invalid character
    4. ORA-00600 : internal error code arguments:[729]'
    [3216],[space leak]

    Investigation Level:

    If we increase the size of "Shared_pool_size" then this
    error is not coming but the other database is being
    affected by this modification in share_pool_size and
    reporting the shared memory error.
    Recently , the size of "Shared_pool_size" is 10485760 in
    the init.ora of a problemetic database.

    This error was identified in "alert" log file.

    [Edited by Debansu on 05-28-2002 at 04:32 AM]

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    ORA-00911 invalid character

    Cause: Special characters are valid only in certain places. If special characters other than $, _, and # are used in a name and the name is not enclosed in double quotation marks ("), this message will be issued. One exception to this rule is for database names; in this case, double quotes are stripped out and ignored.

    Action: Remove the invalid character from the statement or enclose the object name in double quotation marks.

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Report to Oracle. Could be a bug.

    Sanjay

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