A script-enabled browser is required for this page to function properly.

DEBUG.SETX built-in procedure

This pocedure sets the value of a local variable to a new value.

Syntax

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

varname

A VARCHAR2 or CHAR (DEBUG.SETC converts CHAR values to VARCHAR2), DATE, PLS_INTEGER, or NUMBER variable.

newvalue

An appropriate value for varname.

Usage notes

This is useful when you want to change a local's value from a debug trigger.

Example


/*
** 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');

See also

About the DEBUG built-in package

DEBUG built-in package