How to test stored procuders???/

Answer Posted / shilpa

You have two alternatives. One is to create a stored
procedure that executes the procedure under development. It
will call the procedure with every combination of input
parameters possible. The second is to use the command
window as a client, and call the procedures from there.
This re-routes the server's error messages to the command
line, where you can trap them to a file and read them
outside Query Analyzer.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is an sql query executed in oracle 8?

664


Hi, I am writing ISTQB foudation exam on 9 June 2010. Anyone please send me pdf of the book "Sample Exam Questions: ISTQB Certified Tester Foundation Level (Paperback)by John A. Estrella " to hsdantot@yahoo.com Thanks Sree

1518


Which testing method is used to check the software in abnormal condition?

596


What is oo function testing?

608


Best institute for protocol testing in Hyderabad ? How will be the market for protocol testing ?

1801






What is non-intrusive testing?

708


In real time how you do the soak testing?

555


Mention what the different types of test coverage techniques are?

624


Explain testing?

598


Why is incremental integration preferred over 'big bang' integration?

859


Explain what is 'test plan driven' or 'key word driven' method of testing?

875


What is life cycle?

553


What is Functional, Non-Functional, and Regression used for (i.e. the purpose of each)?

720


We use the output of the requirement analysis, the requirement specification as the input for writing …

836


Explain test bed?

544