OraFAQ Forum: Reports & Discoverer » update through reports

Sat, 11 March 2006 07:45

mdamjad
Messages: 45
Registered: May 2005

Member

Is there any method to update a table from reports

Mon, 13 March 2006 01:23

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yes; put the code into one of report triggers (for example, "Before Report" trigger). It should look like this:

UPDATE emp e SET
  e.sal = e.sal + 100;
COMMIT;
RETURN (TRUE);

Previous Topic:	Oracle MVIEW Refresh Error for Discoverer
Next Topic:	report sent

Goto Forum:

]

Current Time: Mon Jul 01 10:26:31 CDT 2024