File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Murach's Java Servlets and JSP this week in the Servlets 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.

Consider Paul's rocket mass heater.
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.