Oracle stored-proc (1)

[LeO Welsch]

Hello,

I am searching in the RFE-list and find, that the Oracle-plugin should support Create-stored-procedures. Trying to run something like:


procedure rename_profile(p_profile_id in number, p_new_profile_name in varchar2 ) is
  begin
  UPDATE PROFILE t SET t.name = p_new_profile_name WHERE t.profile_id = p_profile_id ;
  exception
    when DUP_VAL_ON_INDEX then
     rollback;
     raise_application_error( -20000, '' );  
end;


fails, because it only creates the procedure-name, but miss the content. So, is it a Bug, a feature or should I raise a RFE?

I am running 2.6.5a, with Java 1.6 and no special settings.

???

LeO
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[manningr]

On Mon, May 19, 2008 at 4:29 AM, LeO Welsch <leo_zen@...> wrote:

Hello,

I am searching in the RFE-list and find, that the Oracle-plugin should support Create-stored-procedures. Trying to run something like:


procedure rename_profile(p_profile_id in number, p_new_profile_name in varchar2 ) is
 begin
 UPDATE PROFILE t SET t.name = p_new_profile_name WHERE t.profile_id = p_profile_id ;
 exception
   when DUP_VAL_ON_INDEX then
    rollback;
    raise_application_error( -20000, '' );
end;


fails, because it only creates the procedure-name, but miss the content. So, is it a Bug, a feature or should I raise a RFE?

This is found in a package body, correct?  If so, support for creating packages was added in release 2.6.4.  What release are you using?

Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[manningr]

SQuirreL 2.6.5a should execute that just fine.  Could you submit a test script that is simple but demonstrates the problem? 

Rob

On Tue, May 20, 2008 at 8:43 AM, LeO Welsch <leo_zen@...> wrote:

I do not know, what is the proper mail-address to respond. So, I just use this.

-------- Original-Nachricht --------
> Datum: Mon, 19 May 2008 20:11:11 -0400
> Von: "Robert Manning" <robert.m.manning@...>
> An: "LeO Welsch" <leo_zen@...>
> CC: squirrel-sql-users@...
> Betreff: Re: [Squirrel-sql-users] Oracle stored-proc (1)

> On Mon, May 19, 2008 at 4:29 AM, LeO Welsch <leo_zen@...> wrote:
>
> > Hello,
> >
> > I am searching in the RFE-list and find, that the Oracle-plugin should
> > support Create-stored-procedures. Trying to run something like:
> >
> >
> > procedure rename_profile(p_profile_id in number, p_new_profile_name in
> > varchar2 ) is
> >  begin
> >  UPDATE PROFILE t SET t.name = p_new_profile_name WHERE t.profile_id =
> > p_profile_id ;
> >  exception
> >    when DUP_VAL_ON_INDEX then
> >     rollback;
> >     raise_application_error( -20000, '' );
> > end;
> >
> >
> > fails, because it only creates the procedure-name, but miss the content.
> > So, is it a Bug, a feature or should I raise a RFE?
> >
>
> This is found in a package body, correct?  If so, support for creating
> packages was added in release 2.6.4.  What release are you using?
>
> Rob

2.6.5a.

create or replace package body RBA_RIGHTS is

....
procedure ....

end RBA_RIGHTS;
/


Does this help more?

LeO
--
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users