Home » SQL & PL/SQL » SQL & PL/SQL » query on triggers... reply asap...
query on triggers... reply asap... [message #186701] Wed, 09 August 2006 02:36 Go to next message
Messages: 6
Registered: March 2005
Location: Pondicherry
Junior Member
hello friends,

i have few queries :

1) i have a variable of type NUMBER, if user inputs other than number, i would like to catch that EXCEPTION and i don't want to end the program, i would like give a msg and want to continue... how to handle this situation??

2) i have a situation to invoke some procedure at some time based on system time... is there any provision for it...?

pls help me in this regard

thank you Smile
Re: query on triggers... reply asap... [message #186708 is a reply to message #186701] Wed, 09 August 2006 03:29 Go to previous message
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
1. One way would be to use an overloaded package procedure, 1 that accepts a number, 1 that accepts varchar2 (maybe even another that accepts a date) Check out the pl/sql reference for Overloading.


ps - "reply asap" Don't put stuff like that in your posts. Replies will come when people have the answer and have time to give it. We don't care if it's urgent. Smile

Previous Topic: Create Unique Constraint using Execute immediate
Next Topic: Avoiding Hardcoding folder paths
Goto Forum:

Current Time: Fri Jul 28 12:20:16 CDT 2017

Total time taken to generate the page: 0.04988 seconds