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

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

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...> 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...* <joj...@ci...>)
> 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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>