Re: SQLPLUS fails when there is an extra line in the sql ?

On Feb 15, 11:25 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Feb 15, 1:14 pm, John <chunj..._at_gmail.com> wrote:
>
>
>
>
>
> > This may have been reported by someone, but I just want to share it
> > with you, just in case.
>
> > I am using sqlplus ( Release 10.1.0.5.0 - Production), on my linux
> > box. Usually I am using this command to access a databae to execute a
> > "deploy.sql" that invokes another hundreds sql files, such as:
> > "
> > sqlplus username/password_at_mydatabase @deploy.sql
> > ",
>
> > And here is the piece of the sql that gives me the headache.
> > "
> > CREATE TABLE "DM_ENUM"
> >    (    "CLASS_NAME" VARCHAR2(60 BYTE),
> >         "MEMBER_NAME" VARCHAR2(60 BYTE),
> >         "MEMBER_ORDER" NUMBER
>
> >    );
> > ",
> > as you can see there is an extra blank line before the right
> > parenthesis, and because of that, I see such errors in my log file,
> > "
> > SP2-0042: unknown command ") " - rest of line ignored.
> > ".
>
> > But If I manually remove that blank line, everything works fine.
>
> > I wonder if there is a patch, or higher version of sqlplus that have
> > such problem solved ?
>
> > John
>
> It isn't a problem.  A  blank line in a SQL statement terminates that
> statement:
>
> SQL> select empno, empname,
>   2   deptno,
>   3  hiredate
>   4
> SQL> from emp;
> SP2-0042: unknown command "from emp" - rest of line ignored.
> SQL>
>
> And it isn't a bug.  It's the accepted behaviour SQL*Plus has been
> exhibiting for years.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

Hi David
Can you try the sql that I gave, to see if the table is being created ?

John. Received on Fri Feb 15 2008 - 13:37:04 CST