Interested to Buy Any Domain ? << Click Here >> for more details...
how to test stored procedures in manually?
- 6 Answers
- 18608 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / janaki.bayya
we are calling the stored procedure by using with exec
command or by calling from another program.
ex: Exec proc1 {pass parameters}
for a table class having the columns like cno number
cs char
ex: exec proce1 111,'abc'
| Is This Answer Correct ? | 4 Yes | 1 No |
hi this is janaki
i will tell u with example
we have class table with columns as
create table class
( cn number,
cname varchar2(15),
csize number):
class table created.
now we create a procedure for this table
create procedure proce1(@cno,@cn,@cs)
as
begin
if @cs>20
begin
insert into class values(@cno,@cn,@cs)
end
else
print 'csize should be greater than 20'
end
--procedure created.
we can make use of the 'exec(execute) command to call a
procedure by passing the parameters.
Exec proc1 111,'abc',35
these values to be inserted in class table.
this is the way we have to test stored procedures.ok.
Janaki.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sasidhar
@janaki
oh janaki thanks a lot , ur explanation is very much useful
to me
but i need more help from u
can i expect any test cases for this process and how to do
negative testing
| Is This Answer Correct ? | 3 Yes | 0 No |
hi sasidhar
depending on the project we will write testcases
for ex: in project class table is there
for that class table we have one stored procedure.
so we have to write the testcase like
input description:
"executing the stored procedure proce1 with input values
input data: (111,'abc',35)or take the input data from
database class table
expected results:the data shouble be inserted into class table
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sasidhar
hi janaki.bayya
thanks for ur reply
but i am unable to follow can u give step by step process
and can u clear what is exec command?
| Is This Answer Correct ? | 1 Yes | 2 No |
What is the difference between System Testing and Functionality Testing?
what is the format for usecase?
Who are all involved in an inspection meeting?
Integraton testing
Whether the testing process followed in different model will be same or will it vary?
what methods will u follow to prepare testcases in ur org?
What is CRUD testing
please mention critical bugs in hospital management system i.e in project has 4 modules likeappointments,patient chart,reports,pharmacy like that
What is Fulltime testing?
What are the major testcase design techniques?
List the considerations in developing testing methodology
when 200 testcases are to be written in a single day, then what will you do?
Automation Testing 
