how to test stored procedures in manually?
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 Diff between UAT and QA?
Is Beta Testing done by devolopers or testers?
9.Data – driver automation typically includes?
Which one is done first, either testcases or test scenario?
Write the test cases for sending a message through mobile phone (assuming all the scenarios )Its urgent .....
What do you mean by Cause Effect Graphing? in which standard its mentioned?
what is the use of end to end testing?we r donig every testing like system and functional testing ect..
what are the different methods to test a product in 'Japanese' language? NOTE:User is unable to perform basic functionalities while using the app..(copy, paste, text selection etc.)
What is online testing?
1.what is the approach while writing test cases in your project. 2.tell some intresting scenareo in your project
If the bug is found by customer and he will put that bug in DTS , that bug is visible 1 - Dev Team 2 - Test Team 3 - B. A. Team 4 - 1 & 2
How to do risk management?