John schrieb:

please try

set sqlblanklines on

hth

Urs Metzger

On Feb 15, 2:17*pm, Urs Metzger <u... (AT) ursmetzger (DOT) de> wrote:
Such a resourceful person. And I've learned something else new today.

Thank you.


David Fitzjarrell

On Feb 15, 2:17*pm, Urs Metzger <u... (AT) ursmetzger (DOT) de> wrote:
Such a resourceful person. And I've learned something else new today.

Thank you.


David Fitzjarrell

On Feb 15, 2:17*pm, Urs Metzger <u... (AT) ursmetzger (DOT) de> wrote:
Such a resourceful person. And I've learned something else new today.

Thank you.


David Fitzjarrell

On Feb 15, 2:17*pm, Urs Metzger <u... (AT) ursmetzger (DOT) de> wrote:
Such a resourceful person. And I've learned something else new today.

Thank you.


David Fitzjarrell

John (chunji08 (AT) gmail (DOT) 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@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 ?

As pointed out elsewhere, you can change this sqlplus behaviour (starting
what version, no idea), and it is not a bug but the way sqlplus works.

The point of my message is to point out that when using sqlplus
interactively this is indeed a useful feature. You get to interact with
sqlplus in the middle of typing sql.

E.g.

SQL> select * from
2
SQL> define y=3
SQL> col dummy format a20
SQL> i
2 dual where 3=&y.
3
SQL> /
old 2: dual where 3=&y.
new 2: dual where 3=3

DUMMY
--------------------
X

1 row selected.

That example is pointless, but in real work the ability to interact with
sqlplus independently of the running of SQL statements is very convenient,
and is not a "bug" to be fixed.

$0.10

John (chunji08 (AT) gmail (DOT) 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@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 ?

As pointed out elsewhere, you can change this sqlplus behaviour (starting
what version, no idea), and it is not a bug but the way sqlplus works.

The point of my message is to point out that when using sqlplus
interactively this is indeed a useful feature. You get to interact with
sqlplus in the middle of typing sql.

E.g.

SQL> select * from
2
SQL> define y=3
SQL> col dummy format a20
SQL> i
2 dual where 3=&y.
3
SQL> /
old 2: dual where 3=&y.
new 2: dual where 3=3

DUMMY
--------------------
X

1 row selected.

That example is pointless, but in real work the ability to interact with
sqlplus independently of the running of SQL statements is very convenient,
and is not a "bug" to be fixed.

$0.10

John (chunji08 (AT) gmail (DOT) 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@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 ?

As pointed out elsewhere, you can change this sqlplus behaviour (starting
what version, no idea), and it is not a bug but the way sqlplus works.

The point of my message is to point out that when using sqlplus
interactively this is indeed a useful feature. You get to interact with
sqlplus in the middle of typing sql.

E.g.

SQL> select * from
2
SQL> define y=3
SQL> col dummy format a20
SQL> i
2 dual where 3=&y.
3
SQL> /
old 2: dual where 3=&y.
new 2: dual where 3=3

DUMMY
--------------------
X

1 row selected.

That example is pointless, but in real work the ability to interact with
sqlplus independently of the running of SQL statements is very convenient,
and is not a "bug" to be fixed.

$0.10

John (chunji08 (AT) gmail (DOT) 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@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 ?

As pointed out elsewhere, you can change this sqlplus behaviour (starting
what version, no idea), and it is not a bug but the way sqlplus works.

The point of my message is to point out that when using sqlplus
interactively this is indeed a useful feature. You get to interact with
sqlplus in the middle of typing sql.

E.g.

SQL> select * from
2
SQL> define y=3
SQL> col dummy format a20
SQL> i
2 dual where 3=&y.
3
SQL> /
old 2: dual where 3=&y.
new 2: dual where 3=3

DUMMY
--------------------
X

1 row selected.

That example is pointless, but in real work the ability to interact with
sqlplus independently of the running of SQL statements is very convenient,
and is not a "bug" to be fixed.

$0.10