DEBUG.SETX
built-in procedureThis pocedure sets the value of a local variable to a new value.
PROCEDURE DEBUG.SETC
(varname VARCHAR2,
newvalue VARCHAR2);
PROCEDURE DEBUG.SETD
(varname VARCHAR2,
newvalue DATE);
PROCEDURE DEBUG.SETI
(varname VARCHAR2,
newvalue PLS_INTEGER);
PROCEDURE DEBUG.SETN
(varname VARCHAR2,
newvalue NUMBER);
Parameter |
Description |
|
A |
|
An appropriate value for varname. |
This is useful when you want to change a local's value from a debug trigger.
/*
** Set the value of the local variable 'my_emp' from a
** Debug Trigger
*/
DEBUG.SETC('my_emp', 'SMITH');
/*
** Set the value of the local variable 'my_date' from a
** Debug Trigger
*/
DEBUG.SETD('my_date', '02-OCT-94');
About the DEBUG
built-in package
Copyright © 1984, 2005, Oracle. All rights reserved.