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

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 Received on Fri Feb 15 2008 - 13:25:55 CST