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'

Answer / janaki

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.

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

Answer / janaki

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

Answer / sasidhar

hi janaki my special thanks to you
tou have given quick replies to me

Do u know how to test proxy servers in manual testing?

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?

What types of code coverage do you know?

1 Answers   3i Infotech,

Hi,Any body taking real time classes on manual testing.If u know please let me know in my E-Mail-id: anbarasu2k@gmail.com mob no:09740297798

4 Answers  

What are the advantages of waterfall model?

0 Answers  

Explain three tier architechture of the java project? what is the web server and what is the database server?

1 Answers   Infosys,

Can you explain exploratory testing?

0 Answers  

If you have 1000 test cases which takes atleast 4 months for execution and now project has to be delivered within 2 weeks how will you execute your test cases. Which ones should be executed first.

11 Answers   GXS,

If you find a crashing bug and the developer resolves it Not Repro, what would you do? What if s/he resolves it as Won’t Fix?

0 Answers  

Hi....Friends....If anybody having Sample CSTP question papers, pls send it to the following Id... Thanks n advance... theramkumar@gmail.com

0 Answers  

What are the object repositories for QTP????friends Plz help me in finding answer for the above....thanq

1 Answers  

I am doing manual testing for one website application. already i had prepared test case report,bug tracking report. now i need to perform functional testing of the application and prepare function test report. so can u send one model of the functional test report to me.. it is very helpful to me. my id is sunaruna84@gmail.com

0 Answers   SoftSquare,

IS Mutation testin and error seeding the same....if not can anyone tell me the difference???

2 Answers  

Guys, can any one of u give the realtime example for System Test

2 Answers