urgent recursive SQL level 1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: urgent recursive SQL level 1

  1. #1
    Join Date
    May 2002
    Posts
    232
    hii,i am try to access the remote procedure,i get a error
    but sessions/per user is unlimit.
    SQL> EXEC GET_OCS_BALANCE('163162516',:R1,:R2);
    BEGIN GET_OCS_BALANCE('163162516',:R1,:R2); END;

    *
    ERROR at line 1:
    ORA-04052: error occurred when looking up remote object
    SYSADM.GET_OCS_BALANCE@PPB_LINK.DIGI.COM.MY
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
    ORA-02063: preceding line from PPB_LINK
    thanks
    kavitha
    kavitha

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is the value set for JOB_QUEUE_PROCESSES in the init.ora files of remote and local DBs?

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You don't have enough sessions defined on your remote box.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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