Ok lo deje asi:
Código SQL
[-]
CREATE PROCEDURE ADJUNTO(
ID INTEGER,
HOJADVIDA CHAR(1) CHARACTER SET NONE COLLATE NONE,
FOTO CHAR(1) CHARACTER SET NONE COLLATE NONE,
CED CHAR(1) CHARACTER SET NONE COLLATE NONE,
TITULOS CHAR(1) CHARACTER SET NONE COLLATE NONE,
REFERENCIAS CHAR(1) CHARACTER SET NONE COLLATE NONE,
RP CHAR(1) CHARACTER SET NONE COLLATE NONE,
EXAM CHAR(1) CHARACTER SET NONE COLLATE NONE)
AS
DECLARE VARIABLE Cedula VARCHAR(20);
DECLARE VARIABLE dd INTEGER;
BEGIN
EXECUTE procedure CONSULTACEDULA(:Cedula) RETURNING_VALUES dd;
INSERT INTO TADJUNTOSEMPL (ID_EMPLEADOS,HOJADEVIDA,FOTOCARNET,COPIACED,
COPIATITULOS,REFERENCIAS,RECORDPOLICIACO,EXAMEMBARAZO)
VALUES (:dd,:HOJADVIDA,:FOTO,:CEDULA,:TITULOS,:REFERENCIAS,:RP,:EXAM);
SUSPEND;
END^
Pero me manda este error:
Cita:
Validation error for column ID_EMPLEADOS, value "*** null ***".
At procedure 'ADJUNTO' line: 19, col: 1.
|
en mi db si existe ese empleado con esa identificacion
pero me manda ese error...
Saludos