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

Thread: Problem Running Stored Proc

  1. 01-15-2005, 07:57 AM #1
    aghosha
    aghosha is offline Junior Member
    Join Date
    Mar 2001
    Posts
    15

    Question Problem Running Stored Proc

    Hi,
    I am having a very typical problem running a stored proc from any client application. (SQLPLUS/VB or JAVA). The proc is running for hours and getting stuck in a particular INSERT into SELECT statement. But the same proc is running as expected if submitted as a DBMS_JOB. This problem started arising once we moved into 9i. In 8i
    we never had this problem. Any Idea?

    Thanks
    Reply With Quote Reply With Quote
  2. 01-15-2005, 09:00 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    trace it, see what you are waiting on
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width