squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] String to date conversion error despiteglobal prefs

[<jan...@ya...>]

Wow, I didn't know I can pass DBDATE in the connection string! 
Thanks Doug!

Doug Lawry <la...@ni...> wrote:       I am now back in the office and have checked how I applied this in practice  on my installation. I appended the JDBC URL with (for UK):
  
     ;DBDATE=DMY4/;DBCENTURY=C
  
 You might also want to set DBCENTURY as I have done, which means Informix  will convert 2-digit years to whichever is closest to the current date.
   
 I didn't need to set GL_DATE or GL_DATETIME.
  
 Regards, 
Doug Lawry 
www.douglawry.webhop.org
  
  
  

 ----- Original Message -----  From: Doug Lawry  
 To: jan...@ya... 
 Cc: squ...@li...  ; Robert Manning 
 Sent: Monday, July 02, 2007 8:07 AM
 Subject: Re: [Squirrel-sql-users] String to date conversion error  despiteglobal prefs

 

 Hi Jane.
  
 Try setting environment variable DBDATE and/or GL_DATE, which can be used  in an Informix client process to change the date string format. In USA, you  would normally use:
  
     DBDATE=MDY4/
     GL_DATE=%D
  
 As these are supposed to be the default, I expect one of them is set to  something else in the Informix engine.
  
 There is also GL_DATETIME for DATETIME representation. The default is  "%Y-%m-%d %H:%M:%S", for example producing "2006-12-31 10:45" (depending on  precision).
  
 Alternatively, you can use built-in functions TO_DATE and TO_CHAR in an  Informix SQL statement to convert between string and DATE or DATETIME values  using a specified GLS format using the same conventions  as GL_DATETIME.
  
 See: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp
  
 Regards, 
Doug Lawry 
www.douglawry.webhop.org
  
  
  
 ----- Original Message -----  From: jan...@ya... 
 To: squ...@li...  
 Sent: Sunday, July 01, 2007 10:58 PM
 Subject: Re: [Squirrel-sql-users] String to date conversion error  despiteglobal prefs

 

Robert, 
thanks for the response.

I tried to use the  "date" function using a MM/DD/YYYY  format:

date('02/02/2002')

 but I get the same  error.

Now the thing is, if I use a non-java based client, like winsql  (which is not that great compared to squirrel) for example, all's fine, although  I have no setting that tells winsql how to treat a date literal. So I don't  think the problem lies with the database configuration itself, but with jdbc,  because some Java apps I've written in Java also default the date literal to  'yyyy/mm/dd'. Is there a way to change this thru  squirrel?

Thanks.



Robert Manning  wrote:  On    6/22/07, jan...@ya... wrote:
>    Hi,
>
> I get a "String to date conversion error" when I'm trying    to do this:
>
> update bla set blabla='6/21/2007'

It looks    like the database is performing an implicit conversion (you
gave it a    string and the column is a date - it needs to reconcile that
somehow). I'm    guessing here as I have little knowledge of Informix.
Generally, date types    can be obtained by using a date function on a
string that has a date format    that the date function can understand.
I suppose the first format you chose    was not what the implicit
conversion was expecting. You should consult your    Informix product
manual for guidance on what the format of date strings can    be and if
there are date functions that can/should be used.

The date    datatype format choices in SQuirreL apply to how dates are
displayed and    edited. So, any SQL with date strings that you execute
goes to the database    as is.

Rob

Re: [Squirrel-sql-users] String to date conversion error despiteglobal prefs

[Doug L. <la...@ni...>]

I am now back in the office and have checked how I applied this in =
practice on my installation. I appended the JDBC URL with (for UK):

    ;DBDATE=3DDMY4/;DBCENTURY=3DC

You might also want to set DBCENTURY as I have done, which means =
Informix will convert 2-digit years to whichever is closest to the =
current date.

I didn't need to set GL_DATE or GL_DATETIME.

Regards,=20
Doug Lawry=20
www.douglawry.webhop.org



----- Original Message -----=20
From: Doug Lawry=20
To: jan...@ya...=20
Cc: squ...@li... ; Robert Manning=20
Sent: Monday, July 02, 2007 8:07 AM
Subject: Re: [Squirrel-sql-users] String to date conversion error =
despiteglobal prefs


Hi Jane.

Try setting environment variable DBDATE and/or GL_DATE, which can be =
used in an Informix client process to change the date string format. In =
USA, you would normally use:

    DBDATE=3DMDY4/
    GL_DATE=3D%D

As these are supposed to be the default, I expect one of them is set to =
something else in the Informix engine.

There is also GL_DATETIME for DATETIME representation. The default is =
"%Y-%m-%d %H:%M:%S", for example producing "2006-12-31 10:45" (depending =
on precision).

Alternatively, you can use built-in functions TO_DATE and TO_CHAR in an =
Informix SQL statement to convert between string and DATE or DATETIME =
values using a specified GLS format using the same conventions as =
GL_DATETIME.

See: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp

Regards,=20
Doug Lawry=20
www.douglawry.webhop.org



----- Original Message -----=20
From: jan...@ya...=20
To: squ...@li...=20
Sent: Sunday, July 01, 2007 10:58 PM
Subject: Re: [Squirrel-sql-users] String to date conversion error =
despiteglobal prefs


Robert,=20
thanks for the response.

I tried to use the "date" function using a MM/DD/YYYY format:

date('02/02/2002')

 but I get the same error.

Now the thing is, if I use a non-java based client, like winsql (which =
is not that great compared to squirrel) for example, all's fine, =
although I have no setting that tells winsql how to treat a date =
literal. So I don't think the problem lies with the database =
configuration itself, but with jdbc, because some Java apps I've written =
in Java also default the date literal to 'yyyy/mm/dd'. Is there a way to =
change this thru squirrel?

Thanks.



Robert Manning wrote:=20
  On 6/22/07, jan...@ya... wrote:
  > Hi,
  >
  > I get a "String to date conversion error" when I'm trying to do =
this:
  >
  > update bla set blabla=3D'6/21/2007'

  It looks like the database is performing an implicit conversion (you
  gave it a string and the column is a date - it needs to reconcile that
  somehow). I'm guessing here as I have little knowledge of Informix.
  Generally, date types can be obtained by using a date function on a
  string that has a date format that the date function can understand.
  I suppose the first format you chose was not what the implicit
  conversion was expecting. You should consult your Informix product
  manual for guidance on what the format of date strings can be and if
  there are date functions that can/should be used.

  The date datatype format choices in SQuirreL apply to how dates are
  displayed and edited. So, any SQL with date strings that you execute
  goes to the database as is.

  Rob

Re: [Squirrel-sql-users] String to date conversion error despiteglobal prefs

[Doug L. <la...@ni...>]

Hi Jane.

Try setting environment variable DBDATE and/or GL_DATE, which can be =
used in an Informix client process to change the date string format. In =
USA, you would normally use:

    DBDATE=3DMDY4/
    GL_DATE=3D%D

As these are supposed to be the default, I expect one of them is set to =
something else in the Informix engine.

There is also GL_DATETIME for DATETIME representation. The default is =
"%Y-%m-%d %H:%M:%S", for example producing "2006-12-31 10:45" (depending =
on precision).

Alternatively, you can use built-in functions TO_DATE and TO_CHAR in an =
Informix SQL statement to convert between string and DATE or DATETIME =
values using a specified GLS format using the same conventions as =
GL_DATETIME.

See: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp

Regards,=20
Doug Lawry=20
www.douglawry.webhop.org



----- Original Message -----=20
From: jan...@ya...=20
To: squ...@li...=20
Sent: Sunday, July 01, 2007 10:58 PM
Subject: Re: [Squirrel-sql-users] String to date conversion error =
despiteglobal prefs


Robert,=20
thanks for the response.

I tried to use the "date" function using a MM/DD/YYYY format:

date('02/02/2002')

 but I get the same error.

Now the thing is, if I use a non-java based client, like winsql (which =
is not that great compared to squirrel) for example, all's fine, =
although I have no setting that tells winsql how to treat a date =
literal. So I don't think the problem lies with the database =
configuration itself, but with jdbc, because some Java apps I've written =
in Java also default the date literal to 'yyyy/mm/dd'. Is there a way to =
change this thru squirrel?

Thanks.



Robert Manning <rob...@gm...> wrote:=20
  On 6/22/07, jan...@ya... wrote:
  > Hi,
  >
  > I get a "String to date conversion error" when I'm trying to do =
this:
  >
  > update bla set blabla=3D'6/21/2007'

  It looks like the database is performing an implicit conversion (you
  gave it a string and the column is a date - it needs to reconcile that
  somehow). I'm guessing here as I have little knowledge of Informix.
  Generally, date types can be obtained by using a date function on a
  string that has a date format that the date function can understand.
  I suppose the first format you chose was not what the implicit
  conversion was expecting. You should consult your Informix product
  manual for guidance on what the format of date strings can be and if
  there are date functions that can/should be used.

  The date datatype format choices in SQuirreL apply to how dates are
  displayed and edited. So, any SQL with date strings that you execute
  goes to the database as is.

  Rob

Re: [Squirrel-sql-users] String to date conversion error despite global prefs

[<jan...@ya...>]

Yes, I tried {d 'yyyy-mm-dd'}, it doesn't work. Even it would work, I'm not interested in yyyy-mm-dd, but in mm/dd/yyyy...

Thanks

Robert Manning <rob...@gm...> wrote: On 7/1/07, jan...@ya...  wrote:
> Robert,
> thanks for the response.
>
> I tried to use the "date" function using a MM/DD/YYYY format:
>
> date('02/02/2002')
>
>  but I get the same error.
>
> Now the thing is, if I use a non-java based client, like winsql (which is
> not that great compared to squirrel) for example, all's fine, although I
> have no setting that tells winsql how to treat a date literal. So I don't
> think the problem lies with the database configuration itself, but with
> jdbc, because some Java apps I've written in Java also default the date
> literal to 'yyyy/mm/dd'. Is there a way to change this thru squirrel?

The JDBC API supports an escape syntax that the driver can translate
and it looks like:

{d 'yyyy-mm-dd'}

which the driver is supposed to translate into the appropriate format
for the database.  Have you tried that?

Rob

Re: [Squirrel-sql-users] String to date conversion error despite global prefs

[Robert M. <rob...@gm...>]

On 7/1/07, jan...@ya... <jan...@ya...> wrote:
> Robert,
> thanks for the response.
>
> I tried to use the "date" function using a MM/DD/YYYY format:
>
> date('02/02/2002')
>
>  but I get the same error.
>
> Now the thing is, if I use a non-java based client, like winsql (which is
> not that great compared to squirrel) for example, all's fine, although I
> have no setting that tells winsql how to treat a date literal. So I don't
> think the problem lies with the database configuration itself, but with
> jdbc, because some Java apps I've written in Java also default the date
> literal to 'yyyy/mm/dd'. Is there a way to change this thru squirrel?

The JDBC API supports an escape syntax that the driver can translate
and it looks like:

{d 'yyyy-mm-dd'}

which the driver is supposed to translate into the appropriate format
for the database.  Have you tried that?

Rob

Re: [Squirrel-sql-users] String to date conversion error despite global prefs

[<jan...@ya...>]

Robert, 
thanks for the response.

I tried to use the "date" function using a MM/DD/YYYY format:

date('02/02/2002')

 but I get the same error.

Now the thing is, if I use a non-java based client, like winsql (which is not that great compared to squirrel) for example, all's fine, although I have no setting that tells winsql how to treat a date literal. So I don't think the problem lies with the database configuration itself, but with jdbc, because some Java apps I've written in Java also default the date literal to 'yyyy/mm/dd'. Is there a way to change this thru squirrel?

Thanks.



Robert Manning <rob...@gm...> wrote: On 6/22/07, jan...@ya...  wrote:
> Hi,
>
> I get a "String to date conversion error" when I'm trying to do this:
>
> update bla set blabla='6/21/2007'

It looks like the database is performing an implicit conversion (you
gave it a string and the column is a date - it needs to reconcile that
somehow).  I'm guessing here as I have little knowledge of Informix.
Generally, date types can be obtained by using a date function on a
string that has a date format that the date function can understand.
I suppose the first format you chose was not what the implicit
conversion was expecting.  You should consult your Informix product
manual for guidance on what the format of date strings can be and if
there are date functions that can/should be used.

The date datatype format choices in SQuirreL apply to how dates are
displayed and edited.  So, any SQL with date strings that you execute
goes to the database as is.

Rob

Re: [Squirrel-sql-users] String to date conversion error despite global prefs

[Robert M. <rob...@gm...>]

On 6/22/07, jan...@ya... <jan...@ya...> wrote:
> Hi,
>
> I get a "String to date conversion error" when I'm trying to do this:
>
> update bla set blabla='6/21/2007'

It looks like the database is performing an implicit conversion (you
gave it a string and the column is a date - it needs to reconcile that
somehow).  I'm guessing here as I have little knowledge of Informix.
Generally, date types can be obtained by using a date function on a
string that has a date format that the date function can understand.
I suppose the first format you chose was not what the implicit
conversion was expecting.  You should consult your Informix product
manual for guidance on what the format of date strings can be and if
there are date functions that can/should be used.

The date datatype format choices in SQuirreL apply to how dates are
displayed and edited.  So, any SQL with date strings that you execute
goes to the database as is.

Rob

Re: [Squirrel-sql-users] String to date conversion error despite global prefs

[<jan...@ya...>]

Does anybody know anything about this?

"jan...@ya..." <jan...@ya...> wrote: Hi,

I get a "String to date conversion error" when I'm trying to do this:

update bla set blabla='6/21/2007' 

despite having in the global prefs, data type controls, date, the "use default format (2007-06-22)" unchecked, and for "or locale-dependent format: Short (6/21/2007)" selected.

Am I doing something wrong?

I checked/unchecked the "allow inexact format on input", same result.
If I change my update to say '2007/06/21', I don't get the exception anymore.

This is the informix driver, 2.5, windows.

Thank you.



-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] creating a mysql stored procedure

[Dan C. <dc...@my...>]

Is there a way to creat a stored procedure in MySQL using Squirre=
l-SQL?

I have a valid stored procedure that I can create in the db using=
 a mysql <filename.sql

Every attempt to run this query through squirrel results in synta=
x errors.
I've tried a DELIMTER // command and changing the session delimit=
er, but that didn't work.

Thanks,
Dan

Re: [Squirrel-sql-users] Execution plan

[Robert M. <rob...@gm...>]

On 6/26/07, Richard Fenn (RT) <Fe...@te...> wrote:
>
>  Can you recommend where I can get this plugin from? I tried to get it
> from the squirrel site --- but there seems to be a problem with downloading
>

Each of the plugins can be selected when using the installer. You can re-run
the installer and install additional plugins at any time - in case you
missed them the first time you installed. Alternatively, you can download
the "optional" zip archive and simply extract and use it - it contains all
of the plugins.

Rob

[Squirrel-sql-users] Lost Aliases

[Kessler, D. <Dav...@Le...>]

I am using version 2.5.1 with jdk1.5_10 on Windows XP.

=20

I used Squirrel several days ago, added some aliases, used them then
shut the program down.

=20

Now, every time I use squirrel and add aliases to it and close the
program, then open it again, the aliases I added are gone. In other
words, if I add more aliases and close the program, they are not present
when I open the program again. I just have the four aliases I created
several days ago.=20

=20

Any ideas?

=20

Thanks!

=20

Re: [Squirrel-sql-users] Execution plan

[Robert M. <rob...@gm...>]

On 6/26/07, Richard Fenn (RT) <Fe...@te...> wrote:
>
>  Hi there
>
>
>
> Can anyone tell me how to create an execution plan using Squirrel?
>

The Oracle plugin adds a tab to the result panel of the SQL execution tab.
I don't believe any other plugins have a similar feature.  This is
database-specific so if it's not Oracle, you will need to consult your
product manual to determine how it provides execution plans for queries.

Rob

[Squirrel-sql-users] Execution plan

[Richard F. (RT) <Fe...@te...>]

Hi there=20

=20

Can anyone tell me how to create an execution plan using Squirrel?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at=20
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[Squirrel-sql-users] execution plans

[Richard F. (RT) <Fe...@te...>]

Hi

=20

Can anyone tell me how to create an execution plan using Squirrel

=20

=20

=20



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at=20
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Re: [Squirrel-sql-users] Plugin download page?

[Robert M. <rob...@gm...>]

On 6/24/07, Ruffin Bailey <ru...@gm...> wrote:
> Most of the links to plugin downloads point here:
>
> http://sourceforge.net/project/showfiles.php?group_id=28383
>
> I see a few versions of SQuirreL SQL, but no plugins.  Anybody know
> where I'd get the beta, etc, plugins?

I've been meaning to revise the plugins page for a while :)  All of
our plugins are provided in the installer now.  We used to keep them
separate, but we found that versioning headaches took time away from
other development tasks.  So, the installer will allow you to choose
which of the plugins to install.  Our installer is a bit bigger for
it, but no one has complained and it seems to have cut down the number
of issues related to versioning.  I'll try to update the plugins page
to make that more obvious.

Rob

[Squirrel-sql-users] OT: Invitation to participate in research project

[Ben A. <ben...@st...>]

Hello there

I would greatly appreciate a small amount of your time to assist with
my doctoral research at The University of Newcastle. The research
concerns open source licensing and we're seeking developers working on
Java projects. The research is supervised, ethics-approved, anonymous
and results will be freely available. Participation will also provide a
custom licensing report for your project. To learn more, please visit:

   http://licensing-research.newcastle.edu.au

Thanks for reading this email, and I hope you'll consider participating.

Best regards
Ben Alex

(My apologies for being off-topic; this list will not be emailed again)

[Squirrel-sql-users] Plugin download page?

[Ruffin B. <ru...@gm...>]

Most of the links to plugin downloads point here:

http://sourceforge.net/project/showfiles.php?group_id=28383

I see a few versions of SQuirreL SQL, but no plugins.  Anybody know
where I'd get the beta, etc, plugins?

Thanks for the help, and AIA if I've missed something right in front of my nose!

[Squirrel-sql-users] String to date conversion error despite global prefs

[<jan...@ya...>]

Hi,

I get a "String to date conversion error" when I'm trying to do this:

update bla set blabla='6/21/2007' 

despite having in the global prefs, data type controls, date, the "use default format (2007-06-22)" unchecked, and for "or locale-dependent format: Short (6/21/2007)" selected.

Am I doing something wrong?

I checked/unchecked the "allow inexact format on input", same result.
If I change my update to say '2007/06/21', I don't get the exception anymore.

This is the informix driver, 2.5, windows.

Thank you.

Re: [Squirrel-sql-users] Trouble executing storedprocs in SQuirreL

[Robert M. <rob...@gm...>]

On 6/21/07, Maury Hammel <ml1...@sh...> wrote:
> The problem here is that SQuirreL, by default, uses the semi-colon as a
> terminator.  So it is breaking up the begin/end block into two
> statements, which Oracle chokes on.  In order to get SQuirreL to send
> the entire begin/end block as a single statement, you need to go to the
> SQL tab in the Session Properties dialog, and change the "Statement
> Separator" to something other than an semi-colon.  What I usually did
> was change it to the / (slash) character.  Then you can run the
> procedure with the following:

This is no longer necessary when using the Oracle Plugin.  It uses a
custom QueryTokenizer that handles stored procedures and anonymous
blocks using Oracle's "/" terminator.  See my previous email.

Rob

Re: [Squirrel-sql-users] Trouble executing storedprocs in SQuirreL

[Maury H. <ml1...@sh...>]

Rob Cope wrote:
> I've never had any luck running anonymous PL/SQL blocks outside  
> Oracle's tools (though I would love info on getting it to work, if it  
> can be done).
> 
> For your example, you could try this instead:
> 
> 	select DELETE_BY_LOAN('123435') from dual;

That will only work if DELETE_BY_LOAN is a function that returns a 
value.  If it is a procedure, you'll get an error.

>> 	begin DELETE_BY_LOAN('123435'); end;
>>
>> And then I press Ctrl-enter.  When I do this, it says:
>>
>> ------------
>> Error: java.sql.SQLException: ORA-06550: line 1, column 44:
>> PLS-00103: Encountered the symbol "end-of-file" when expecting one of
>> the following:
>>

The problem here is that SQuirreL, by default, uses the semi-colon as a 
terminator.  So it is breaking up the begin/end block into two 
statements, which Oracle chokes on.  In order to get SQuirreL to send 
the entire begin/end block as a single statement, you need to go to the 
SQL tab in the Session Properties dialog, and change the "Statement 
Separator" to something other than an semi-colon.  What I usually did 
was change it to the / (slash) character.  Then you can run the 
procedure with the following:

begin delete_by_loan('12345'); end/

(I can't remember for sure, but you may still need the semi-colon after 
the "end" but before the slash)


Maury

Re: [Squirrel-sql-users] Command completion stopped working

[Andrew Z. <wo...@zg...>]

I figured this out just after sending the email... the ctrl key wasn't
working in any app. I rebooted and it works again.

On 20/06/07, Andrew Zahra <wo...@zg...> wrote:
>
> I have been using squirrel for a couple of days. It had been working
> great, including the command line completion, but it has now stopped
> working. When I press ctrl-space I just get a space :(
>
> I have restarted squirrel a number of times and the problem persists. Any
> suggestions as to how to work around this?
>
> I am using squirrel with Oracle 9i jdbc thin driver on OSX with jdk
> 1.5.0_07.
>
> thanks,
> Andrew
>
> --
> Zahra Consulting Services
> www.zcs.com.au




-- 
Zahra Consulting Services
www.zcs.com.au

[Squirrel-sql-users] Command completion stopped working

[Andrew Z. <wo...@zg...>]

I have been using squirrel for a couple of days. It had been working great,
including the command line completion, but it has now stopped working. When
I press ctrl-space I just get a space :(

I have restarted squirrel a number of times and the problem persists. Any
suggestions as to how to work around this?

I am using squirrel with Oracle 9i jdbc thin driver on OSX with jdk 1.5.0_07
.

thanks,
Andrew

-- 
Zahra Consulting Services
www.zcs.com.au

Re: [Squirrel-sql-users] Trouble executing storedprocs in SQuirreL

[Rob C. <rw...@co...>]

I've never had any luck running anonymous PL/SQL blocks outside  
Oracle's tools (though I would love info on getting it to work, if it  
can be done).

For your example, you could try this instead:

	select DELETE_BY_LOAN('123435') from dual;

Rob

On Jun 18, 2007, at 1:22 PM, Karr, David wrote:

> I'm having trouble executing a storedproc in SQuirreL (2.5).  If the
> name of the storedproc is "DELETE_BY_LOAN" and it takes a single  
> string
> parameter, what exactly should I type in the SQL window?
>
> I would guess it would be:
>
> 	begin DELETE_BY_LOAN('123435'); end;
>
> And then I press Ctrl-enter.  When I do this, it says:
>
> ------------
> Error: java.sql.SQLException: ORA-06550: line 1, column 44:
> PLS-00103: Encountered the symbol "end-of-file" when expecting one of
> the following:
>
>    := . ( % ;
> , SQL State: 65000, Error Code: 6550
> Error occured in:
> begin DELETE_BY_LOAN('123435')
> ------------
>
> I tried the similar test in SQLDeveloper, and it works fine.
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] Trouble executing storedprocs in SQuirreL

[Karr, D. <dav...@wa...>]

I'm having trouble executing a storedproc in SQuirreL (2.5).  If the
name of the storedproc is "DELETE_BY_LOAN" and it takes a single string
parameter, what exactly should I type in the SQL window?

I would guess it would be:

	begin DELETE_BY_LOAN('123435'); end;

And then I press Ctrl-enter.  When I do this, it says:

------------
Error: java.sql.SQLException: ORA-06550: line 1, column 44:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of
the following:

   :=3D . ( % ;
, SQL State: 65000, Error Code: 6550
Error occured in:
begin DELETE_BY_LOAN('123435')
------------

I tried the similar test in SQLDeveloper, and it works fine.

[Squirrel-sql-users] Accessing result tab popup?

[<da...@ce...>]

Newbie here, so apologies offered in advance. I'm unable to find the  
api to add a menu item to the popup in a result tab. Anyone done this  
before?

Also - anyone have a good chunk of example code for using the result  
tab event listener?

My thanks,
D