Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Posts
    34

    Unanswered: Executing stored procedure from SQl developer

    I modified a stored procedure in SQL Dveloper.

    I compiled it and it compiled and in the messages box it gave as compiled
    But while i am running it, i am getting a running log as

    Connecting to the Database
    Process Exited
    DIsconnecting from the database

    What does that mean?
    Is the stored procedure executed or is there any problem?

  2. #2
    Join Date
    Nov 2009
    Posts
    1
    It means process is completed successfully.......

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    That looks like you're running the procedure in DEBUG mode, without any breakpoints. At least, those messages about connecting & disconnecting are consistent with that manner of running a procedure (it connects with another connection/thread).

    If you just ran something like the following in a SQL Worksheet, you'll get a different message, maybe more of like what you're expecting:

    Code:
    BEGIN
      my_proc();
    END;
    Run it using F5 (Run Script). It'll give you a message like "anonymous block completed".

    --=cf

Posting Permissions

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