@@@ Oracle Trigger Question, Konchem Oracle Vallu Help Seyyandi@@@

[Kakateyudu]

[quote name='padmasri123' timestamp='1347289744' post='1302454811']


idi work avvaledha
[/quote]
meru seppina vidham ga ne sesa baa asalu pani seyyatla trigger endo... aa publising table loki em records pettatled edo chinna bokka pettam ani na doubt

[padmasri123]

[quote name='Kakateeyudu©' timestamp='1347290662' post='1302454879']
meru seppina vidham ga ne sesa baa asalu pani seyyatla trigger endo... aa publising table loki em records pettatled edo chinna bokka pettam ani na doubt
[/quote]

Records will be fetched only when the trigger IF condition works....meeru cheppinattu u want the trigger to run only when the current date value is null and when you fetch a new value...

I dont know whether it satifies your requirment or not!!

[Kakateyudu]

[quote name='padmasri123' timestamp='1347291375' post='1302454935']

Records will be fetched only when the trigger IF condition works....meeru cheppinattu u want the trigger to run only when the current date value is null and when you fetch a new value...

I dont know whether it satifies your requirment or not!!
[/quote]

null to non null update chesa baa value but fire avvaledu ento... wrong place lo if rasana endhi

[Kakateyudu]

IF UPDATING THEN
IF UPDATING('TRANSACTION_ID') THEN
RAISE updating_key_fields;
END IF;
INSERT INTO KAKA_P_INT_OUTBOUND VALUES (
:OLD.TRANS_ID,
:NEW.OBJECT_NAME,
son on ..................


painadhi original working trigger for any values updated, ..

nenu eppudu

IF (UPDATING and (:OLD.READY_DATE = NULL and :NEW.READY_DATE !=NULL)) inappude publish chei aa values

P table lo ki ani seppali.... aa if condition paina danlo ekkada paste seyyali bhayyaaaa

[khulfi_123]

[color=#333333][font=helvetica, arial, sans-serif]IF UPDATING('TRANS_ID') THEN[/font][/color]
[color=#333333][font=helvetica, arial, sans-serif]RAISE updating_key_fields;[/font][/color]
[color=#333333][font=helvetica, arial, sans-serif]END IF;[/font][/color]

[color=#333333][font=helvetica, arial, sans-serif][b]Raise updating key fields[/b] enduku bhayya? [/font][/color]

[vijay2349]

oracle forums lo veyyi..ikkada kanna akkda machi replied vastayi