SQL*Plus options in Toad (some of them are errors)

Toad for Oracle - Beta
1

Hi

Toad 12.7.0.16 x64 on 11.2.0.3 (client) against 11.2.0x(server)

When I run some default set in sqlplus I get no errors, In toad when I run:

set appinfo OFF
set appinfo “SQLPlus"
set arraysize 15
set autocommit OFF
set autoprint OFF
set autorecovery OFF
set autotrace OFF
set cmdsep OFF
set colsep " "
set compatibility NATIVE
set concat “.”
set copycommit 0
set copytypecheck ON
set define “&”
set describe DEPTH 1 LINENUM OFF INDENT ON
set echo OFF
set editfile “afiedt.buf”
set embedded OFF
set escape OFF
set feedback 6
set flagger OFF
set flush ON
set heading ON
set headsep “|”
set linesize 300
set logsource “”
set long 5000
set longchunksize 80
set markup HTML OFF HEAD " body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} h1 {font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;}SQLPlus Report” BODY “” TABLE “border=‘1’ width=‘90%’ align=‘center’ summary=‘Script output’” SPOOL OFF ENTMAP ON PRE OFF
set newpage 1
set null “”
set numformat “”
set numwidth 10
set pagesize 100
set pause OFF
set recsep WRAP
set recsepchar " "
set serveroutput OFF
set shiftinout invisible
set showmode OFF
set sqlblanklines OFF
set sqlcase MIXED
set sqlcontinue "> "
set sqlnumber ON
set sqlplus compatibility 11.2.0
set sqlprefix “#”
set sqlterminator “;”
set suffix “sql”
set tab ON
set termout ON
set time OFF
set timing ON
set trimout ON
set trimspool OFF
set underline “-”
SET VERIFY OFF
set wrap ON

I get errors.

unknown command “sqlplus” - rest of line ignored.
unknown command “sqlplus” - rest of line ignored.
unknown command “sqlplus” - rest of line ignored.
unknown command “sqlplus” - rest of line ignored.
unknown command “sqlplus” - rest of line ignored.
unknown command “sqlplus” - rest of line ignored.

I do not know which option is making error, but this is easy to test running previous example. Maybe if you find time, you can fix next versions to work with all sqlplus set options.

Brg
Damir

2

Looks like our parser doesn’t like the following:

set concat
“.”

set define "&"

set headsep "|"

set recsepchar " "

set sqlplus compatibility 11.2.0

set sqlprefix "#"

set sqlterminator ";"

set underline "-"

I’ve opened a ticket with our parser team.

Thanks,

Greg

From: Damir Vadas [mailto:bounce-damirvadas_250@toadworld.com]

Sent: Tuesday, November 25, 2014 6:08 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] SQL*Plus options in Toad (some of them are errors)

SQL*Plus options in Toad (some of them are errors)

Thread created by Damir Vadas

Hi

Toad 12.7.0.16 x64 on 11.2.0.3 (client) against 11.2.0x(server)

When I run some default set in sqlplus I get no errors, In toad when I run:

set appinfo OFF

set appinfo “SQL*Plus”

set arraysize 15

set autocommit OFF

set autoprint OFF

set autorecovery OFF

set autotrace OFF

set cmdsep OFF

set colsep " "

set compatibility NATIVE

set concat “.”

set copycommit 0

set copytypecheck ON

set define “&”

set describe DEPTH 1 LINENUM OFF INDENT ON

set echo OFF

set editfile “afiedt.buf”

set embedded OFF

set escape OFF

set feedback 6

set flagger OFF

set flush ON

set heading ON

set headsep “|”

set linesize 300

set logsource “”

set long 5000

set longchunksize 80

set markup HTML OFF HEAD " body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;}
table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} h1 {font:16pt
Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White;
margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;}SQL*Plus Report" BODY “” TABLE “border=‘1’ width=‘90%’ align=‘center’
summary=‘Script output’” SPOOL OFF ENTMAP ON PRE OFF

set newpage 1

set null “”

set numformat “”

set numwidth 10

set pagesize 100

set pause OFF

set recsep WRAP

set recsepchar " "

set serveroutput OFF

set shiftinout invisible

set showmode OFF

set sqlblanklines OFF

set sqlcase MIXED

set sqlcontinue "> "

set sqlnumber ON

set sqlplus compatibility 11.2.0

set sqlprefix “#”

set sqlterminator “;”

set suffix “sql”

set tab ON

set termout ON

set time OFF

set timing ON

set trimout ON

set trimspool OFF

set underline “-”

SET VERIFY OFF

set wrap ON

I get errors.

unknown command “sqlplus” - rest of line ignored.

unknown command “sqlplus” - rest of line ignored.

unknown command “sqlplus” - rest of line ignored.

unknown command “sqlplus” - rest of line ignored.

unknown command “sqlplus” - rest of line ignored.

unknown command “sqlplus” - rest of line ignored.

I do not know which option is making error, but this is easy to test running previous example. Maybe if you find time, you can fix next versions to work with all sqlplus set options.

Brg

Damir

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

3

same for

set colinvisible OFF

set exitcommit ON

set fullcolname OFF

set xmloptimizationcheck OFF

4

I’m getting

SQL> set sqlplus compatibility 11.2.0

SP2-0158: unknown SET option “sqlplus”

5

Also

SQL> set colinvisible OFF

SP2-0735: unknown SET option beginning “colinvisib…”

SQL> set fullcolname OFF

SP2-0735: unknown SET option beginning “fullcolnam…”

SQL> set xmloptimizationcheck OFF

SP2-0735: unknown SET option beginning “xmloptimiz…”

I’m using 11.2.0 here so I guess that this must be 12c stuff.

Ok will implement.

Thanks,

Andre

6

set sqlplus compatibility 11.2.0

should be

set sqlpluscompatibility 11.2.0

Brg

Damir

7

I’m wondering in which Oracle release FULLCOLNAME was introduced…