Tag: parameters

PL/SQL – Don’t mix and match scope

Here’s a simple little PL/SQL block where we call an inner procedure PARAMETER_TESTER from its parent block. Pay particular attention to the parameter we pass to the procedure, and it’s value throughout the execution of that procedure. SQL> set serverout on SQL> declare 2…

Idle banter

When your car gets a flat tyre, it’s always handy to have a spare.  We do the same with the database SQL> select 2 x.ksppinm name 3 from 4 sys.x$ksppi x, 5 sys.x$ksppcv2 y 6 where 7 x.inst_id = userenv(‘Instance’) and 8 y.inst_id =…