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?

Are Test Condition and Test Description/Procedure are different? Please Reply

1 Answers  

developers take most of the time for coding and tester left very few time for testing say 2 days which testing u find best when ur project is run out of time and product is going to be released

3 Answers  

Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain

0 Answers  

We can check many things in one test case, then Is it necessary to write separate test case for checking each functionality? Example : For Login Window --> Test Case is---> 1) Enter valid user id & password --> For this expected result --> 1) User should login. My question --> while executing above valid test case, we can expect more than one result such as "Visibility of password should be as ****" So Should I have to write separate test case for "Visibility of Password" OR Not? Please guide me properly.

5 Answers  

What is the difference between SIT AND IST?

0 Answers   TCS,

what is the main difference between client server and webserver???

4 Answers   FIC, IBM, TCS,

Exact Difference between Sanity and Smoke Testing

6 Answers   Virtusa,

Apart from testing what are ypur roles as a tester.

0 Answers  

what is mean by test environment?

5 Answers  

1.What is configuration Management? 2. Explain Impact Analysis 3. Explain Peer Review 4. what i kickoff phase of Formal Review. 5. Whatv are the phases of fundamental test process. 6. what is state transition testing. 7. what is LCSAJ 8. Test conditions are derived from where?

0 Answers  

How to monitor test progress?

0 Answers   3i Infotech,

Can v prepare Test cases only from BRS from Tester point of view?

9 Answers   Sapient,