Terrence Wong <mingjun_at_singnet.com.sg> wrote in article
<33DD58F0.94EDD222_at_singnet.com.sg>...
> Srini Narayanan wrote:
> >
[SNIP]
> > return ostr ;
> > exception
> > dbms_output.put_line('The field is greater tha MAX') ;
> >
> > end ;
>
> Try inserting the "WHEN str_err THEN" statement.
>
> > exception
WHEN str_err THEN
> > dbms_output.put_line('The field is greater tha MAX') ;
>
>
> Hope this solves your problem.
> Terrence Wong
> Systems Developer
>
If you want to return an error to the caller, then use
raise_application_error instead of dbms_output.put_line.
--
Miles Thomas
Logica UK Ltd
thomasm "at" logica "dot" com
The above are personal opinions, and are
not necessarily the opinions of my employer.
Received on Tue Aug 05 1997 - 00:00:00 CDT
