[Squirrel-sql-users] Trouble executing storedprocs in SQuirreL

[Karr, D. <dav...@wa...>]

I'm having trouble executing a storedproc in SQuirreL (2.5).  If the
name of the storedproc is "DELETE_BY_LOAN" and it takes a single string
parameter, what exactly should I type in the SQL window?

I would guess it would be:

	begin DELETE_BY_LOAN('123435'); end;

And then I press Ctrl-enter.  When I do this, it says:

------------
Error: java.sql.SQLException: ORA-06550: line 1, column 44:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of
the following:

   :=3D . ( % ;
, SQL State: 65000, Error Code: 6550
Error occured in:
begin DELETE_BY_LOAN('123435')
------------

I tried the similar test in SQLDeveloper, and it works fine.