Re: Stop SQL execution by disconnecting Database Connection ???



Hi,

"Rinu Gopalakrishna Pillai"
<RinuGopalakrishnaPillai@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF8F72AA-B2BE-432A-B601-FA706FF48AE9@xxxxxxxxxxxxxxxx
Hi All,

I have a ASP/C# application that connect to Oracle database . After
issuing my SQL query if I close the browser or move into another page ( ie
whle executing in the databse serevr) will the SQL execution in server
continue or immediately stop.If it still continue how I can stop the
execution (by disconnecting the present database connection ???).

I'm not very sure of how it will work, but I'm pretty sure that the
execution will continue, up to the point where the engine is ready to start
sending back some response, at this point as the client broke the connection
it will get an error and most posibly discard the processing.

If you do not get a good answer here you should post this in other groups,
as the same apply no matter what language you are using.


.



Relevant Pages

  • Re: Status Column in sysobjects table...SQL2000
    ... What I mean is when i complie the same piece of code through SQL Query ... Analyser and through isql it behaves in a different manner when executed. ... procedure the execution or the run time behaviour is different for identical ...
    (microsoft.public.sqlserver.programming)
  • Re: Paginate from group by
    ... distributing the SQL query on several pages. ... but I'm having a tough time trying to paginate ... exit() here will just stop the execution, ...
    (comp.lang.php)
  • Re: Paginate from group by
    ... distributing the SQL query on several pages. ... but I'm having a tough time trying to paginate ... echo 'No Record was Selected'; ... exithere will just stop the execution, ...
    (comp.lang.php)
  • Re: ORA-8102, why?
    ... i've an Oracle database with RAC 2 node version 10.1.0.5 on Linux ... got an error ORA-8102 during the execution of a procedure that was ... The notes say also that dropping and recreating the index ...
    (comp.databases.oracle.server)
  • Re: ORA-8102, why?
    ... i've an Oracle database with RAC 2 node version 10.1.0.5 on Linux ... Suse SLES9 64 bit. ... got an error ORA-8102 during the execution of a procedure that was ...
    (comp.databases.oracle.server)

Loading