Multiple stored procedures within a stored procedure and waiting

I have seen several posts similar to this but none with a strait forward answer. Sorry if this is a stupid question, I have taught myself SQL and am still learning.

I have a stored procedure that a user starts from an Excel document. That stored procedure runs several other stored procedures. These internal stored procedures need to run in sequence. My question is, will stored procedure 2 wait for stored procedure 1 to finish before starting?

I need to make sure that the second one does not start before the first one finishes.

Answers


As Ben indicates, it would be helpful to specify which database you're using because every database's procedural extensions to SQL (PL/SQL in Oracle, T-SQL in SQL Server, etc.) are different. That being said, however, I am not aware of any database that would do anything other than have stored procedure 1 run to completion, then run stored procedure 2. That's true of any procedural language, whatever is on line N of a procedure has to run to completion before whatever is on line N+1 of that procedure can run.


Need Your Help

Where should I put this configuration setting?

java web-applications configuration java-ee

I'm designing a fairly small web application which will run on a Sun application server (v9.1). It only has a few pages, no database of its own, and will retrieve/update data via web services. Ther...

Convert HTML string to JavaScript text keeping indentation

javascript komodoedit

I want to target or match only the first occurrence per line