Geeks Talk

Prepare for your Next Interview


Welcome to the Geeks Talk forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Where does the execution stops exactly

This is a discussion on Where does the execution stops exactly within the SQL forums, part of the Databases category; Procedure 'a' and procedure 'b' - two procedures are there. Now I am calling procedure 'b' from 'a'. In procedure 'b' I used one exception, that exception is having error ...

Go Back   Geeks Talk > Databases > SQL
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read
  #1 (permalink)  
Old 06-09-2007
Expert Member
 
Join Date: Feb 2007
Posts: 1,279
Thanks: 0
Thanked 192 Times in 154 Posts
Geek_Guest has a spectacular aura aboutGeek_Guest has a spectacular aura aboutGeek_Guest has a spectacular aura about
Where does the execution stops exactly

Procedure 'a' and procedure 'b' - two procedures are there.
Now I am calling procedure 'b' from 'a'.
In procedure 'b' I used one exception, that exception is having error
So.. Now where does the execution stops exactly....

Thanks,
Somesh..
Question asked by visitor somesh
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-11-2007
Contributing Member
 
Join Date: Jun 2007
Location: Bangalore
Posts: 32
Thanks: 3
Thanked 33 Times in 6 Posts
vcyogi is on a distinguished road
Re: Where does the execution stops exactly

Procedure 'B'
Reply With Quote
  #3 (permalink)  
Old 06-28-2007
Contributing Member
 
Join Date: Apr 2007
Location: bangalore
Posts: 46
Thanks: 0
Thanked 9 Times in 9 Posts
reetasharma108 is on a distinguished road
Re: Where does the execution stops exactly

Execution will stop as soon as exception occur in procedure b.
Reply With Quote
  #4 (permalink)  
Old 06-28-2007
Expert Member
 
Join Date: Jun 2006
Location: India
Posts: 413
Thanks: 15
Thanked 43 Times in 31 Posts
jamesravid will become famous soon enough
Re: Where does the execution stops exactly

No...the control goes to exception section of Procedure A...If the exception handled in A's exception section then that block of code will get executed...
__________________
Cheers,
:) James:)
Reply With Quote
  #5 (permalink)  
Old 07-02-2007
Junior Member
 
Join Date: Jun 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
surekhasetty is on a distinguished road
Re: Where does the execution stops exactly

The point at which u called procedure 'b' in procedure 'a' will stop the execution of procedure 'b', which causes to stop procedure 'a'.
Reply With Quote
  #6 (permalink)  
Old 07-02-2007
Junior Member
 
Join Date: Jun 2007
Location: tirupati
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
thanoojmca is on a distinguished road
Re: Where does the execution stops exactly

Execution will continue at the topmost exception handler.
continuation of pro a event ..........
Reply With Quote
Reply

  Geeks Talk > Databases > SQL

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Best solution for this to increase the speed of execution kawareapeksha SQL 2 07-10-2007 05:56 AM
How time you took to prepare review, case design, execution, reporting... JobHelper Testing Issues 3 04-19-2007 03:42 AM
Data Execution Prevention Manojks Windows 1 02-08-2007 01:30 PM
Program Execution norman C and C++ 5 11-12-2006 03:14 PM
Execution time-out error Lokesh M PHP 2 11-03-2006 02:23 AM


All times are GMT -4. The time now is 09:29 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved