Thank you for prompt response. The syntax you mentioned works perfectly.


Cheers, Jojo

+44 79 0381 5270


From: Robert Manning []
Sent: 09 September 2011 00:10
To: Thomas, Jojo John [CCC-OT_IT]
Subject: Re: [Squirrel-sql-users] Executing a stored procedure in Oracle


If you have the SQuirreL Oracle plugin installed try this:







It should parse correctly and is also valid in SQL-Plus.  The SQL-plus shortcut "exec myProcedure;" won't work however.




On Thu, Sep 8, 2011 at 12:16 PM, Thomas, Jojo John <> wrote:


We are using SQuirreL for access to Oracle – using Oracle Thin Driver.

SQLs run fine, but there seems to be issues executing stored procedures


Using BEGIN myProcedure; END; gives following error message:


java.lang.IllegalArgumentException: No SQL selected for execution.

Position: 0


Using CALL myProcedure gives the following error message:


Error: ORA-06576: not a valid function or procedure name

SQLState:  65000

ErrorCode: 6576

Position: 22



Jojo (jt22629 -

Working from UK/London/CGC1

W. +44 20 7986 7347 M. +44 79 0381 5270



Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.
Squirrel-sql-users mailing list