Rob,

 

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

 

Cheers, Jojo

+44 79 0381 5270

 

From: Robert Manning [mailto:robert.m.manning@gmail.com]
Sent: 09 September 2011 00:10
To: Thomas, Jojo John [CCC-OT_IT]
Cc: squirrel-sql-users@lists.sourceforge.net
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 <jojo.john.thomas@citi.com> 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 - jojo.john.thomas@citi.com)

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