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 is database testing

2 Answers  

what is JAVA TESTING? What Testers will do in JAVA Testing. Can any one Give suitable Ans Pls. it's urgent

0 Answers   IBM,

Beyond the customary advantages of having a testing group, what are the benefits does a company receive from a well run, automated testing group?

0 Answers   TCS,

What are the test methodologies??

10 Answers   Accenture,

Can you tell some body how to test a situation that to sell a share if it reaches 30(present value is 25) and the time limit is 120 days. Every day the market starts from 10 A.M to 3 P.M. it may execute any time with in the time period. Pls tell me the answer.

1 Answers  

what is link testing?

1 Answers  

What a manual tester should know about web servers?what he tests in servers?

3 Answers   Mind Tree,

What is the different between QA&QC? Please give answer with examples?

3 Answers   Nedbank,

Hi friends!! Can u tell me, what is meant by Database Testing? How it can be done? What is tested in it(like any Queries like Select and all are tested or not)?

3 Answers   IBM,

Describe a past experience with implementing a test harness in the development of software.

1 Answers  

Did you have access to all the modules(Requirements, Test plan,Test Lab, Defects, & Dashboard) in Quality Center(QC) or only to some particular ones?

1 Answers   ING,

How the value of P in cyclomatic complexity is calculated? P:The number of connected path.

1 Answers