Re: [Squirrel-sql-users] Executing a stored procedure in Oracle

[Thomas, J. J. <joj...@ci...>]

Rob,

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

Cheers, Jojo
+44 79 0381 5270

From: Robert Manning [mailto:rob...@gm...]
Sent: 09 September 2011 00:10
To: Thomas, Jojo John [CCC-OT_IT]
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] Executing a stored procedure in Oracle

If you have the SQuirreL Oracle plugin installed try this:

begin
    myProcedure;
end;
/

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

Rob

On Thu, Sep 8, 2011 at 12:16 PM, Thomas, Jojo John <joj...@ci...<mailto:joj...@ci...>> 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

Cheers,
Jojo (jt22629 - joj...@ci...<mailto:joj...@ci...>)
Working from UK/London/CGC1
W. +44 20 7986 7347<tel:%2B44%2020%207986%207347> M. +44 79 0381 5270<tel:%2B44%2079%200381%205270>



------------------------------------------------------------------------------
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.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...<mailto:Squ...@li...>
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users