Interested to Buy Any Domain ? << Click Here >> for more details...
How to Debug a Stored Procedure?
- 5 Answers
- 13901 Views
- Allianz, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Using PRINT command in stored procedure.
use print to check if the parameter values are fine.
When the stored procedure is executed then print will show
the output of those parameters/variables.
| Is This Answer Correct ? | 16 Yes | 4 No |
Answer / ris
Steps for debugging stored procedure is given below
1.Open the object browser
2.right click the procedure that u want to debug
3.from the popup menu select debug option
4.from the displayed window ,give the values for input
parameters
5.click the button debug
| Is This Answer Correct ? | 12 Yes | 5 No |
Answer / sivakumar
Steps for debugging stored procedure is given below
1.Open the Microsoft visual Studio
2.Select Server Explorer
3.Add Server
4.Select Database Where Procedure is located
5.Select Procedure for debug
6.Right click and select Step into stored procedure
7.Pass Parameter to that procedure
8.Then Do debug.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / gd
you can find detailed answer here on How to Debug PL/SQL
Stored Procedures in Visual Studio http://bit.ly/15O01NM
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bhagyashri jain
By Command
Execute Procedurename parameter1 ,parameter2,......
u can use
exec Procedurename parameter1 ,parameter2,......
| Is This Answer Correct ? | 1 Yes | 14 No |
What is a dbms wizard?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What the different components in replication and what is their use?
What Are Three Rules to Use UNION IN SQL SERVER
What is function of ROLLUP ?
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
What is #table in sql server?
What is meant by Active-Passive and Active-Active clustering setup?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Explain how to integrate the ssrs reports in application?
How do we get month name in SQL Server 2000, Oracle, MS Access?
What is the maximum size per database for sql server express?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
