This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes Testing and the fly likes How to Test Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Engineering » Testing
Bookmark "How to Test Stored Procedure" Watch "How to Test Stored Procedure" New topic

How to Test Stored Procedure

vinu ganesh

Joined: Sep 29, 2004
Posts: 2
I have tried to find the solutions for testing the stored procedure using WinRunner, but I couldnt find out.

(Tried in Google too)

Can anyone help me


Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
Are you using PL/SQL for those stored procedures?
Have you seen this?

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Edwin Keeton
Ranch Hand

Joined: Jul 10, 2002
Posts: 214

And there's SQLUnit.

I agree. Here's the link:
subject: How to Test Stored Procedure