PLS-00488

Errores PLS 21/03/2017 08:01

Error: PLS-00488: invalid variable declaration: object 'string' must be a type or subtype

Causa: The datatype specifier in a variable declaration does not designate a legal type. For example, the \%TYPE attribute might not have been added to a declaration, as in:

Acción: Make sure the datatype specifier designates a legal type. Remember to use the \%TYPE and \%ROWTYPE attributes when necessary.

COMENTARIOS:

por maria | 25/07/2009 14:05:58

RE: PLS-00488

create or replace procedure pa_empleados_aumentarsueldo(afechaingreso in to_char ,aporcentaje in number default 20) as begin update empleados set sueldo=sueldo+(sueldo*aporcentaje/100) where to_char(sysdate,'yyyy')- to_char(fechaingreso,'yyyy')>ayear; end;