Toad World® Forums

Testing PL/SQL Record


#1

We have only recently started using Code Tester and so far most of the tests have been on REF CURSORs.

However, I am now testing a procedure in a package that takes in an ID and performs a SELECT * FROM <table_name> and returns the row in a PL/SQL table defined with the <table_name>%ROWTYPE declaration.

How do I go about testing the contents of the PL/SQL record?


#2

Please check out the Quick Start Tutorials in the Help doc. They provide examples of testing the contents of records.

SF