Testing PL/SQL Functions and Procedures
See Also
Given below is the process of testing PL/SQL Functions and Procedures.
- Right click on the Function/Procedure and select Create Test Block.
- A new test window will be opened with a code template of the test case.
- Fill in the placeholders. You can traverse between the placeholders by using Tab key.
- Deploy the test block using the PL/SQL Execution toolbar action (Alt-Shift-E).
- Check the output window for any errors.
- See Also
- Creating PL/SQL Source Files
- About Editing PL/SQL Source Files
- Deploying PL/SQL Source Files