This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android 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: 8904

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
Similar Threads
Java Database Connectivity
Stored procedure not being refreshed while accessing through code
J2ee app gets stuck at a stored procedure call
stored procedure inside another stored procedure
How To Call Stored Procedure in JSP.