Re: SQUIRREL_GET_ERROR_OFFSET?

On Dec 3, 2007 3:28 PM, Thomas Han <thomashan@xxxxxxxxx> wrote:
> Hi,
>
> I'm on the latest 2.6.1.  When I upgraded to this at end of Oct.  My DBA
> told me that he started seeing objects in the DB
> "SQUIRREL_GET_ERROR_OFFSET".
>
> What is this and is there a way to disable this so my Squirrel client won't
> create this?  I've been using Squirrel for years and have never been told by
> the DBA about these objects, so I'm just thinking if this is v2.6.1.
> related.

It is a function that the Oracle plugin creates and uses to position
the cursor at the statement token where a syntax error occurred.  It
has the following definition and is created when an Oracle session is
connected while the Oracle plugin is loaded.

create or replace function
 (query IN varchar2)
return number authid current_user
is
     l_theCursor     integer default dbms_sql.open_cursor;
     l_status        integer;
begin
         begin
         dbms_sql.parse(  l_theCursor, query, dbms_sql.native );
         exception
                 when others then l_status := dbms_sql.last_error_position;
         end;
         dbms_sql.close_cursor( l_theCursor );
         return l_status;
end;

Oracle doesn't provide this information via the JDBC driver so it's
not possible to do this without using a function (at least, I couldn't
think of a way).  Unfortunately for you, there is no other way to
disable it's creation other than to disable the Oracle plugin.  It
hadn't occurred to me that user functions were off-limits in some
cases.  I'll make a note to make this configurable in 2.6.3 and 2.7.

Rob

-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4