2 Replies Latest reply on Jul 26, 2016 7:14 PM by 3004645

    Problem with UDR when Style PL/SQL DBMS Output (for older version of SqlDev

    3004645

      Hello Jeff/team and hello all Sql Dev community.

       

      For management reasons, my organization has to use Sql Dev 3.2 because it is shipped with Oracle Client distribution.

      In Sql Dev 3.2 when i use UDR with Style "PL/SQL DBMS Output", i am getting this pop up error:

       

      Missing IN or OUT parameter at index: 1

      Vendor code 17041

       

      The same simple code works just fine with Sql Dev 4.1.

       

      Any help will be greatly appreciated.

      +++++++++++++++++++++++++++++++++

      Here is simple code:

       

      DECLARE

      v_OSUSER varchar2(100);

      v_sqlerrm varchar2(4000);

      v_grantee varchar2(30):='N/A';

      BEGIN

      select SYS_CONTEXT('USERENV','OS_USER') into v_OSUSER from dual;

      ---

      dbms_output.put_line ('<h3 style="color: blue;"> Hello User '''||v_OSUSER||'''</h3>');

      ---

      dbms_output.put_line ('<br><b><i><u> Before adding any new Grantee to the Authorization List, here is a list of all currently existing Grantees: </br></b></i></u>');

      -----

      dbms_output.put_line ('<H3> Now Adding New Grantee, Starting execution at: '''||TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS')||''' </H3>');

      v_grantee := :GRANTEE;

      ---

      dbms_output.put_line ('<H3> Passing Parameter for Grantee: '''||v_grantee||'''</H3>');

      --

      DVSYS.DBMS_MACADM.ADD_AUTH_TO_REALM(

      REALM_NAME => 'EDM Global App Realm',

      GRANTEE =>v_grantee,

      RULE_SET_NAME => NULL,

      AUTH_OPTIONS => DBMS_MACUTL.G_REALM_AUTH_OWNER);

      ---

      dbms_output.put_line ('<H3> Passing Parameter for Grantee: '''||v_grantee||'''</H3>');

      --

      dbms_output.put_line ('<H3>SUCCESS and Ended execution at: '''||TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS')||''' </H3>');

      ---

      EXCEPTION

      ---

      WHEN OTHERS THEN

       

      dbms_output.put_line ('<H3 style="color: red;"> An error was encountered -> '''||SQLERRM||'''. </H3>');

      ---

      dbms_output.put_line ('<br><b><i><u> End of the session list of all Grantees: </br></b></i></u>');

      for j in (select grantee from DVSYS.DBA_DV_REALM_AUTH where realm_name='EDM Global App Realm' order by 1)

      loop

      dbms_output.put_line ('<br>'''||j.grantee||'''</br>');

      end loop;

      ---

      END;

      ---