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'

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?

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.

@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

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

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?