What is the difference between connected and unconnected stored procedures?



What is the difference between connected and unconnected stored procedures?..

Answer / Ajay Krishna

Connected stored procedures execute sequentially, one after another, sharing a common context. Unconnected stored procedures run independently without sharing a common context. Connected procedures can access local variables from each other while unconnected procedures cannot.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What is a data warehousing?

1 Answers  


What are the advantages of cold fusion?

1 Answers  


What are the advantages of query studio compared to report studio?

1 Answers  


What is a hash cluster?

1 Answers  


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

1 Answers  


Explain the data type of the surrogate key?

1 Answers  


What are the approaches used by optimizer during execution plan?

1 Answers  


What is the difference between star and snowflake schemas?

1 Answers  


Explain about core dimension, balanced dimension, and dirty dimension?

1 Answers  


what is the use of surrogate key in businessobjects

3 Answers   EDS,


What is the difference between agglomerative and divisive hierarchical clustering?

1 Answers  


How to create context?

1 Answers  


Categories