1 Reply Latest reply: May 29, 2014 8:35 AM by Jeff Smith Sqldev Pm-Oracle RSS

    12c: dbms_sql.return_result & SQL Developer 4.0.2

    user11982730

      dbms_sql.return_result works in SQL*Plus:

      SQL> declare

        2     src sys_refcursor;

        3  begin

        4     open src for select * from v$version;

        5     dbms_sql.return_result(src);

        6  end;

        7  /

       

      PL/SQL procedure successfully completed.

       

      ResultSet #1

       

      BANNER     CON_ID

      -------------------------------------------------------------------------------- ----------

      Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production  0

      PL/SQL Release 12.1.0.1.0 - Production  0

      CORE 12.1.0.1.0 Production  0

      TNS for Linux: Version 12.1.0.1.0 - Production  0

      NLSRTL Version 12.1.0.1.0 - Production  0

       

      But does not work in SQL Developer (Script Output window):

      Error starting at line : 1 in command -

      declare

         src sys_refcursor;

      begin

         open src for select * from v$version;

         dbms_sql.return_result(src);

      end;

      Error report -

      ORA-29481: Для клиента не могут быть возвращены неявные результаты.

      ORA-06512: на  "SYS.DBMS_SQL", line 2785

      ORA-06512: на  "SYS.DBMS_SQL", line 2779

      ORA-06512: на  line 5

       

       

      About

      -----

       

      Oracle SQL Developer 4.0.2.15

      Version 4.0.2.15

      Build 15.21

       

      IDE Version: 12.1.3.2.41.140418.1111

      Product ID: oracle.sqldeveloper

      Product Version: 12.2.0.15.21

       

      Version

      -------

       

      Component Version

      ========= =======

      Oracle IDE 4.0.2.15.21

      Java(TM) Platform 1.7.0_55

      Versioning Support 4.0.2.15.21