OraFAQ Forum: SQL & PL/SQL » PL/SQL package

Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL package

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL/SQL package [message #19103]

Thu, 28 February 2002 06:20

Joan
Messages: 36
Registered: February 2002

Member

Hi Have big PL/SQl procedure which I need to execute at the end of the month. How do I wrap my entire procedure to an if statement to execute when it is the end of the month? I would like this to be part of the package instead of being called outside of the package.

Thanks

Report message to a moderator

Re: PL/SQL package [message #19106 is a reply to message #19103]

Thu, 28 February 2002 06:59

Jon
Messages: 483
Registered: May 2001

Senior Member

IF LAST_DAY(SYSDATE) - SYSDATE = 0 THEN
.
.
.
END IF;

Report message to a moderator

Re: PL/SQL package [message #19108 is a reply to message #19103]

Thu, 28 February 2002 07:03

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

create a database job and set the interval to one month

Report message to a moderator

Re: PL/SQL package [message #19120 is a reply to message #19108]

Thu, 28 February 2002 23:08

THA
Messages: 26
Registered: February 2002

Junior Member

i dont think it is a good practical solution. then you won't have any control over the process.

Report message to a moderator

Previous Topic:	dbms_sql package
Next Topic:	one column into multiple rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 22:16:29 CDT 2024