CODEWITHSUNDEEP
oracle-databasetestingoracle-sqldeveloper
The PowerHouse
The PowerHouse

Reputation: 560

How can I test the procedure or oracle function?

I have to create a lots of procedure and function in oracle. I am using SQL developer tool. I am a Java professional. In java we can write Junit test cases to validate our code.

Is there any way to do that? Any help would be welcome.

Upvotes: 0

Views: 852

Answers (2)

Bjarte Brandt
Bjarte Brandt

Reputation: 4461

utPLSQL is a unit-testing framework for PLSQL.

http://utplsql.sourceforge.net/

Upvotes: 1

davegreen100
davegreen100

Reputation: 2115

do you mean to validate that the code compiles, or validate that it does what you expect? SQL Developer will show validation errors if there are compilation errors. But i suspect you mean validate the code functions as expected, in which case this link may help you http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/sqldev_unit_test/sqldev_unit_test_otn.htm

Upvotes: 0

Related Questions