 | |
SQLPLUS fails when there is an extra line in the sql ?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SQLPLUS fails when there is an extra line in the sql ? -
02-15-2008
, 01:14 PM
#2
| |||
| |||
|
|
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 ? John |
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
#3
| |||
| |||
|
|
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 ? John |
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
#4
| |||
| |||
|
|
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 ? John |
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
#5
| |||
| |||
|
|
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 ? John |
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
#6
| |||
| |||
|
|
On Feb 15, 1:14*pm, John <chunj... (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 ? 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 - |
Jone
#7
| |||
| |||
|
|
On Feb 15, 1:14*pm, John <chunj... (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 ? 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 - |
Jone
#8
| |||
| |||
|
|
On Feb 15, 1:14*pm, John <chunj... (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 ? 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 - |
Jone
#9
| |||
| |||
|
|
On Feb 15, 1:14*pm, John <chunj... (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 ? 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 - |
Jone
#10
| |||
| |||
|
|
On Feb 15, 1:14*pm, John <chunj... (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 ? 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 - |
Can you try the sql that I gave, to see if the table is being
created ?
John.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.