On Mon, May 19, 2008 at 4:29 AM, LeO Welsch <leo_zen@gmx.at> 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