#617 Don't fail on "set" commands in SQL script

2.6.4
open
5
2008-03-13
2008-02-27
Anonymous
No

This is an enhancement request for changes to the tokenizer in the Oracle plugin. There are some "sqlplus-ism's" that it doesn't recognize. The following is a detailed description of the issue.

I have a sql script that runs fine in Oracle SQL Developer, but it fails when I run it in SQuirreL. I'm sure it's something simple, but I'm not that familiar with this.

The script begins like this:

----------------
set define off
set pagesize 0
set echo off
set verify off
set feed off
set prompt off
set head off
set line 200
set esc on \ ----------------

When I view the script, the "set" on the first line is red, along with the values for pagesize, line, and esc, so perhaps that's an indication of what it's complaining about. When I run the script, it says this (table name changed):

---------------
Error: ORA-00922: missing or invalid option

SQLState: 42000
ErrorCode: 922
Error occured in:
set define off
set pagesize 0
set echo off
set verify off
set feed off
set prompt off
set head off
set line 200
set esc on \

truncate table <tablename>
-------------------

Discussion

  • Rob Manning

    Rob Manning - 2008-02-28
    • labels: 796193 --> Oracle Plugin
     
  • Rob Manning

    Rob Manning - 2008-02-28

    Logged In: YES
    user_id=1287991
    Originator: NO

    This is actually a kind of bug. I'm putting in a fix for it in CVS.

    Rob

     
  • Rob Manning

    Rob Manning - 2008-02-28
    • milestone: --> 2.6.4
    • status: open --> pending
     
  • SourceForge Robot

    Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
  • SourceForge Robot

    • status: pending --> closed
     
  • Rob Manning

    Rob Manning - 2008-03-13
    • status: closed --> open
     
  • Rob Manning

    Rob Manning - 2008-03-13

    Logged In: YES
    user_id=1287991
    Originator: NO

    re-opened as the changes made to the tokenizer to fix this didn't account for

    set esc on \

    I will add this to the testcase and look into getting it fixed.

    Rob

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks