Re: HOW TO EXECUTE DELETE RECORD.

WHERE FECHA =fec AND HORA =hor

should be

WHERE FECHA ='fec' AND HORA ='hor'

Stephen Miller - email: miller_stephen at usa.net

------ Original Message ------

Received: 11:12 AM EST, 03/08/2012

From: Marvin Rios <[email protected]>

To: "[email protected]" <[email protected]>

Subject: [toad] HOW TO EXECUTE DELETE RECORD.

HOW TO EXECUTE DELETE RECORD.

SPEC

PROCEDURE sp_hua_algorithm_hor (fec DATE, hor NUMBER);

BODY

PROCEDURE sp_hua_algorithm_hor (fec IN DATE, hor IN NUMBER)

IS

BEGIN

DELETE FROM SMART3G.HUA_ALGORITHM_HOR

WHERE FECHA =fec AND HORA =hor;

COMMIT;

INSERT INTO HUA_ALGORITHM_HOR (FECHA,

HORA,

CELL,

RNC,

PERIOD_DURATION,

CELLID,

DCCC_D2C_SUCC)

SELECT FECHA,

HORA,

CELL,

RNC,

SUM (PERIOD_DURATION),

CELLID,

SUM (DCCC_D2C_SUCC)

FROM HUA_ALGORITHM_MIN

WHERE fecha = fec AND hora = hor

GROUP BY FECHA,

HORA,

CELL,

RNC,

CELLID;

COMMIT;

END;

Note: When execute delete record send this message

ORA-00904: "HOR": identificador no válido

__._,_.___

Your email settings: Individual Email|Traditional

Change settings via the Web (Yahoo! ID required)

Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured

Visit Your Group |
Yahoo! Groups Terms of Use |
Unsubscribe

__,_._,___