• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

how to reset an expiration date =o in oracle 8i form?

I am developing a form in oracle 11.1.0 form

there is a reset button in trigger with the following code

The problem is

if it shows with  expiration 13-NOV-2008. That's today! Then I wanted to check the reset
reason field, so I reset it again. The new expiration date shows as
12-JAN-2009. I tried it again, and got 11-FEB-2009.

Everytime I reset the download, it upped the expiration date to be
30 days + the current expiration_date.  This is  fault, it should
actually be set to 30 days from the current date.

update xx_downloads
	       expiration_date = nvl(expiration_date,sysdate) + 30,
	       download_attempts = 0,
	       last_updated_by = v_user_id,
	       last_update_date = sysdate
   	 where download_id = :XX_DOWNLOADS_V.download_id;

Open in new window

1 Solution
where ...
and trunc(expiration_date) < trunc(sysdate)

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now