Re: Help needed. How to validate date in PL/SQL(Oracle Web Server)

Hi
I am not sure if this helps.
[Date validation]
You could try to use TO_DATE to convert a string to a date, so that when it fails, you get an exception and you can respond to that.

[Numeric validation]
For the validation of a number you may want to use TO_NUMBER. Same policy as above.

Roel Peeters
Euro-Partners Informatici
r.peeters_at_euro-partners.nl

---
Remove nospam from email address to obtain a valid email address.

Divakar <kimmane_at_email.msn.com> wrote in article
<OHzI$1vc9GA.307_at_uppubnews03>...


> Hi,

> I am working on Oracle web server3.0.

> I hava a problem in validating date fields in PL/SQL.


> Basically I have 2 fields startdate and Enddate both

> are Varchar2(20)in the form which will be enterd by the users.

> Start date ----------(mm/dd/yyyy)

> end date ------------(mm/dd/yyyy)

> Because of company policy, I can use Java to validate

>  at the client end. Now how do I verify enterd dates are valid.

> Is there built in date function to validate this?

> Like we have in ISS(Microsoft) Isdate().

> 

> I have an other problem

> Is there any fuction in Pl/Sql to validate enterd

> field is numeric.? Because I have amount field is varchar2(10).

> 

> Please advice me.(This is bit urgent)

> Thanks,in advance.

> 

> 

>