Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008
    Posts
    26

    Question Unanswered: ora-8103 "object no longerexist"

    Hi

    i m getting a ora error tat object no longer exist while executing the procedure from front end.But when i m running my procedure in sqlplus it is running fine.

    what should be the problem
    ???
    can u help me

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You either have a security issue (grant appropriate priv's) or a synonym problem ... is the user on the "frontend" the same userid running from sqlplus ? ... if not, then check to ensure your procedure is using owner.table_name or you have a public synonym for the objects being referenced.

  3. #3
    Join Date
    Nov 2008
    Posts
    26

    hi

    Actually i m using global tempory table with on commit delete rows in my procedure . And this procedure is used in asp.net application ...

Posting Permissions

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