Re: Recompile invalid packages

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0311061548.5d326487_at_posting.google.com...
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
news:<3fa9892f$0$3502$afc38c87_at_news.optusnet.com.au>...
>
> >
> > Worse. All the 'comments' characters are stil "#"... which we loved in
> > server manager, but which throws errors in SQL Plus. Nice of them to
> > remember they abolished server manager in 9i, no? I mean, didn't the
lights
> > go on: here they are busy coding a totally unnecessary version of the
script
> > to be produced, but someone forgot to join the dots and twig that "#"
should
> > have been replaced by "--".
> >
>
> SQL> #select 'whatup with that first # sign?' from dual;
>
> 'WHATUPWITHTHATFIRST#SIGN?'
> ------------------------------
> whatup with that first # sign?

Try this instead:

SQL># The following commands will create a new control file and use it;

SP2-0734: unknown command beginning "The follow..." - rest of line ignored.

(And guess where that line comes from!)

Now this:

SQL> -- The following commands will create a new control file and use it; SQL> (So if only they'd been consistent, no errors would happen).

I rest my case, your honour.

Regards
HJR
>
> SQL>
>
> Error? What error? :-)
>
> Good rant hjr!
>
> jg
> --
> @home.com is bogus.
>

http://www.signonsandiego.com/news/uniontrib/wed/currents/news_mz1c5tree.html Received on Thu Nov 06 2003 - 18:35:56 CST