Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mock private global variable for unit test PL/SQL

Something RecognizableApr 19 2022 — edited Apr 19 2022

Hello,

My problem is the following.
I wish to test a procedure with a unit test (with Sql Developer).

------------- Procedure ---------------------------------------
CREATE OR REPLACE PROCEDURE() IS
IF global_variable = value 1 THEN
do stuff
ELSE
do other stuff.
---------------------------------------------------------------------

The thing is that this global_variable is private so I can not affect it in the Startup Process.

Does anyone know a way around it ?

Thank you for your help

PS :
I am under Oracle Database 10g so I can not use utPLSQL

Comments
Post Details
Added on Apr 19 2022
2 comments
249 views