I am assuming that some program is calling this and set serverout on is a
sqlplus thing. Instead raise error.
Jim
"Chris ( Val )" <chrisval_at_bigpond.com.au> wrote in message
news:bjvgju$mt2n5$1_at_ID-110726.news.uni-berlin.de...
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in
message
> news:ieH8b.432100$YN5.291419_at_sccrnsc01...
> | "Chris ( Val )" <chrisval_at_bigpond.com.au> wrote in message
> | news:bjvedq$mte60$1_at_ID-110726.news.uni-berlin.de...
> | > Hi everyone, I'm still a newbie with Oracle and PLSQL, and
> | > if possible, I would appreciate your help.
>
> [snip]
>
> Hi Jim.
>
> | Don't use character for date, use date for date. Then you do not have to
> | check if the string looks like a date. Also the dbms_output will not
show
> | up for the user. It might show up for you in sqlplus, but not the user.
> | Also use implicit cursors, much easier to code, faster. (see
> | asktom.oracle.com and look up implicit cursors)
>
> Thank you for your help, I will try your suggestion(s).
>
> I'm also curious why you think it would not show up for the user ?
> Is it because you think that he might not have 'serveroutput' set ?
>
> Cheers.
> Chris Val
>
>
Received on Sat Sep 13 2003 - 12:01:37 CDT
