Re: Need Help with some PLSQL code please

"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 - 11:28:45 CDT