Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need Help with some PLSQL code please
Chris ( Val ) wrote:
>"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
>
>
>
It is almost always the wrong choice to use DBMS_OUTPUT with production
code. You just stated one of the reasons.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sat Sep 13 2003 - 16:20:20 CDT