Re: [Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

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

You need the Oracle plugin for SQuirreL. Go to Help -> Software Update ->
Check(button) -> Ok(button)
Then find the artifact called oracle-assembly.zip and click on the action
value of "NONE" and change it to install.

After its downloaded you will need to restart and agree to install the
update.

Rob

On Thu, Mar 7, 2013 at 10:01 AM, urbanmojo <cra...@gm...>wrote:

> Hi:
>
> I am using Squirrel as the client tool using JDBC RAC driver against Oracle
> 11.1. I am trying to replace an existing Oracle procedure with:
>
> CREATE OR REPLACE PROCEDURE MY_PROC
> AS
> BEGIN
> DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
> DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
> DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
> DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
> END;
>
> It fails with the error:
> Query 1 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.047, SQL
> query: 0.047, Building output: 0
> 6,326 Row(s) Deleted
> Query 2 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.672, SQL
> query: 0.672, Building output: 0
> 12,097 Row(s) Deleted
> Query 3 of 5, Rows read: 0, Elapsed time (seconds) - Total: 1.25, SQL
> query:
> 1.25, Building output: 0
> 5,040 Row(s) Deleted
> Query 4 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.531, SQL
> query: 0.531, Building output: 0
> Error: ORA-00900: invalid SQL statement
>
> SQLState: 42000
> ErrorCode: 900
> Error occured in:
> END
> What am I doing wrong? I've tried different things but nothing seems to
> give
> me an executable procedure.
>
>
>
> --
> View this message in context:
> http://squirrel-sql-client.10976.n7.nabble.com/Can-t-create-Oracle-Procedure-in-Squirrel-tp3082.html
> Sent from the Users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
> Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
> endpoint security space. For insight on selecting the right partner to
> tackle endpoint security challenges, access the full report.
> http://p.sf.net/sfu/symantec-dev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>