Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    india,hyderabad
    Posts
    43

    Unanswered: re: interpretation of SQLPLUS ..

    hi! guys ,

    I was running a proc from sqlplus ...

    It is running since 24 hrs ....

    It should not take that long for it to complete.

    I killed the session.

    When I killed the session I got the following ...

    ------------------------------------------------------
    SQL> @c:\pol.sql

    1 row created.


    PL/SQL procedure successfully completed.

    insert into progress(name,date1) values ('rdlnktsrdatainterpolation1 completed',sysdate)
    *
    ERROR at line 1:
    ORA-00028: your session has been killed
    -------------------------------------------------------
    Am I correct in "assuming that the procedure completed successfully" ..?
    harry

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Am I correct in "assuming that the procedure completed successfully" ..?
    Answer: Maybe YES, maybe NO.
    Why are you asking us, when you are the only one who can answer this question?
    Query table PROGRESS & see if the new record has been committed.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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