My test case s working fine for the INSTR() but the same if i use in implemenation its not raising the error
giving below the pseudo code
IF INSTR (v_lm,pcd,1,1) = 1 OR INSTR(vlm,pc,1,1) = 1 OR INSTR(vlm,pcn,1,1) = 1 THEN
raise_application_error( err_pkg.nt_val, err_pkg.nt_val_msg || sqlerrm);
where v_lm is a local variable in the procedure and pcd,pc and pcn are parameter variables of the procedure
i am trying to implement tat value of v_lm should not start with the values of any of the 3( pcd,pc and pcn )
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!