6 Replies Latest reply on Dec 22, 2017 10:48 AM by PaulC

    Can not view package procedure or function body PL/SQL code

    PaulC

      Environment

       

      Client: Windows 10 64bit

      Client  java version:  Version 8 Update 151

      Server: Linux 7

      Database 12.1 

       

      I've upgrade to 17.3 on a Windows 10 PC from a much earlier version and can no longer access the PL/SQL specification or body code for any package (or procedure, function, trigger).  I can access  table definitions, table data, run sql in worksheets, no problem.  On selecting a package, SQL Developer display a spinning icon for sometime and eventually just returns the line "Create or replace" and no more. 

       

      17.3 was installed on the Windows laptop with the JDK supplied with the download and configured on installation to use this jdk, not the version of java installed on the laptop. 

      I can run SQLDeveloper 4 on the linux server with no problem.

       

      The activity log file on the Windows PC shows an error but I'm not clear on what to fix.  My guess is that 17.3 and 4 connect to the database slightly differently and some parameter in the database needs to be increased to prevent the connection error for 17.3.  The log file is reproduced below:-

       

      SEVERE 128 0 oracle.javatools.buffer.JdkReadWriteLockImplementation$DeadlockScanner Starvation (possible deadlock) detected:

      Oracle SQL Developer 17.3.1 279.0537 (279.0537)

      Oracle Corporation Java 1.8.0_144-b01

      373MB free of 746MB

       

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

      -- Thread Dump

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

       

      "SwingWorker-pool-5-thread-1" id=111 RUNNABLE (in native)

      at sun.nio.ch.SocketDispatcher.read0(Native Method)

      at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:43)

      at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)

      at sun.nio.ch.IOUtil.read(IOUtil.java:197)

      at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380)

      -  locked java.lang.Object@64d47e10

      at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:144)

      at oracle.net.ns.NIOHeader.readHeaderBuffer(NIOHeader.java:82)

      at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:139)

      at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:101)

      at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:80)

      at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:98)

      at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:534)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:485)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)

      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)

      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)

      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)

      at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)

      -  locked oracle.jdbc.driver.T4CConnection@5cb96ca5

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)

      at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCStatement$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeQuery(Unknown Source)

      at oracle.dbtools.db.DBUtil$10.call(DBUtil.java:657)

      at oracle.dbtools.db.DBUtil$10.call(DBUtil.java:647)

      at oracle.dbtools.db.DBUtil.assertLock(DBUtil.java:1747)

      at oracle.dbtools.db.DBUtil.executeOracleQuery(DBUtil.java:673)

      at oracle.dbtools.db.OracleUtil.executeQuery(OracleUtil.java:101)

      at oracle.dbtools.raptor.navigator.net.DBURLStreamHandlerFactory.fetchSource(DBURLStreamHandlerFactory.java:269)

      at oracle.dbtools.raptor.navigator.net.DBURLFileSystemHelper.createReader(DBURLFileSystemHelper.java:168)

      at oracle.ideimpl.net.LazyURLFileSystemHelper.createReader(LazyURLFileSystemHelper.java:365)

      at oracle.ide.net.URLFileSystem.createReader(URLFileSystem.java:1707)

      at oracle.ide.model.TextNode.createReader(TextNode.java:1126)

      at oracle.ide.model.TextNode.loadTextBuffer(TextNode.java:297)

      at oracle.ide.model.TextNode.openImpl(TextNode.java:532)

      at oracle.ide.db.model.BaseDBObjectTextNode.openImpl(BaseDBObjectTextNode.java:144)

      at oracle.dbtools.raptor.navigator.plsql.PlSqlNode.openImpl(PlSqlNode.java:156)

      at oracle.ide.model.Node.open(Node.java:1252)

      at oracle.ide.model.Node.open(Node.java:1199)

      at oracle.ide.model.Node.ensureOpen(Node.java:2650)

      at oracle.ide.model.TextNode.acquireTextBuffer(TextNode.java:762)

      at oracle.dbtools.raptor.oviewer.base.NavSelectionListener$4$1.doInBackground(NavSelectionListener.java:501)

      at oracle.dbtools.raptor.oviewer.base.NavSelectionListener$4$1.doInBackground(NavSelectionListener.java:496)

      at javax.swing.SwingWorker$1.call(SwingWorker.java:295)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at javax.swing.SwingWorker.run(SwingWorker.java:334)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at java.lang.Thread.run(Thread.java:748)

       

       

      Locked synchronizers:

      - java.util.concurrent.ThreadPoolExecutor$Worker@752d845c

      - java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@6a139cfa

      - java.util.concurrent.locks.ReentrantLock$NonfairSync@6e2c1560

       

       

      "AWT-EventQueue-0" id=16 WAITING on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@6a139cfa owned by "SwingWorker-pool-5-thread-1" id=111

      at sun.misc.Unsafe.park(Native Method)

      -  waiting on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@6a139cfa

      at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)

      at java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:836)

      at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireShared(AbstractQueuedSynchronizer.java:967)

      at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireShared(AbstractQueuedSynchronizer.java:1283)

      at java.util.concurrent.locks.ReentrantReadWriteLock$ReadLock.lock(ReentrantReadWriteLock.java:727)

      at oracle.javatools.buffer.JdkReadWriteLockImplementation.lock(JdkReadWriteLockImplementation.java:202)

      at oracle.javatools.buffer.JdkReadWriteLockImplementation.readLock(JdkReadWriteLockImplementation.java:94)

      at oracle.javatools.buffer.ReadWriteLock.readLock(ReadWriteLock.java:188)

      at oracle.ide.model.Node.readLock(Node.java:262)

      at oracle.ide.model.Node.runUnderReadLock(Node.java:1883)

      at oracle.ide.model.TextBufferTracker.getTracker(TextBufferTracker.java:114)

      at oracle.ideimpl.markers.MarkableText.init(MarkableText.java:88)

      at oracle.ideimpl.markers.MarkableText.init(MarkableText.java:60)

      at oracle.ideimpl.markers.MarkableNode.<init>(MarkableNode.java:75)

      at oracle.ideimpl.markers.MarkableText.<init>(MarkableText.java:80)

      at oracle.ideimpl.markers.adapters.TextNodeToMarkableAdapterFactory.adaptImpl(TextNodeToMarkableAdapterFactory.java:72)

      at oracle.ideimpl.markers.adapters.TextNodeToMarkableAdapterFactory.adaptImpl(TextNodeToMarkableAdapterFactory.java:44)

      at oracle.ide.adapters.AbstractCachingAdapterFactory.adapt(AbstractCachingAdapterFactory.java:146)

      at oracle.ideimpl.adapters.AdapterManagerImpl.adapt(AdapterManagerImpl.java:116)

      at oracle.ide.markers.Markable$Adapter.adapt(Markable.java:84)

      at oracle.ideimpl.status.markers.StatusMarkerProvider.addStatusIssues(StatusMarkerProvider.java:186)

      at oracle.ideimpl.status.markers.StatusMarkerProvider.viewSelectionChanged(StatusMarkerProvider.java:142)

      at oracle.ide.view.View.fireViewSelectionChangedImpl(View.java:493)

      at oracle.ide.view.ViewDecorator.fireViewSelectionChangedImpl(ViewDecorator.java:69)

      at oracle.ide.view.View.fireViewSelectionChanged(View.java:483)

      at oracle.ide.view.View.updateSelectionImpl0(View.java:442)

      at oracle.ide.view.View.updateSelectionImpl(View.java:427)

      at oracle.ide.view.View.updateSelection(View.java:306)

      at oracle.dbtools.raptor.navigator.core.NavigatorWindow$1$1.run(NavigatorWindow.java:90)

      at oracle.dbtools.raptor.navigator.core.NavigatorWindow$1.viewSelectionChanged(NavigatorWindow.java:96)

      at oracle.ide.view.View.fireViewSelectionChangedImpl(View.java:493)

      at oracle.ide.view.View.fireViewSelectionChanged(View.java:483)

      at oracle.ide.view.View$2.actionPerformed(View.java:349)

      at javax.swing.Timer.fireActionPerformed(Timer.java:313)

      at javax.swing.Timer$DoPostEvent.run(Timer.java:245)

      at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)

      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)

      at java.awt.EventQueue.access$500(EventQueue.java:97)

      at java.awt.EventQueue$3.run(EventQueue.java:709)

      at java.awt.EventQueue$3.run(EventQueue.java:703)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)

      at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)

      at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

      at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

      at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

       

      Any help would be gratefully received

       

      Thanks

       

      Paul

        • 1. Re: Can not view package procedure or function body PL/SQL code
          thatJeffSmith-Oracle

          Can you open a Service Request with My Oracle Support?

           

          >> from a much earlier version

          How much earlier? Is this version still able to view the PL/SQL?

           

          If you open the Log panel, and advance to the Statements panel, do you see a problematic query popping up when you go to browse the code?

          • 2. Re: Can not view package procedure or function body PL/SQL code
            PaulC

            Hi Jeff

             

            Thanks for the quick response.  Answers to your questions:-

             

            Service Request:  Unfortunately not, company has a policy of raising service requests for production sites only

            Earlier Version.  4.0.2  (it worked, so didn't get changed.  New laptop, installed latest software).  Edited - Yes I can view and edit PL SQL code.

            Log panel.  The last statement displayed in the panel is the sql that relates to the package procedure selected in the Packages panel.  Example below:-

            SQL

              WITH src AS (SELECT ROWNUM,LINE,TEXT,origin_con_id FROM SYS.Dba_SOURCE

              WHERE TYPE = :TYPE AND OWNER = :OWNER AND NAME = :NAME)

              SELECT text FROM src, (SELECT max(origin_con_id) max_orig FROM src)

              WHERE origin_con_id = max_orig

              ORDER BY LINE

            Parameters

                    "OWNER"="SSL", "TYPE"="PACKAGE BODY", "NAME"="AP_HELP_DML"       

            Elapsed time 39173

             

            The elapsed time on a query for e.g. a table query would be < 200

             

            If I run the query in a worksheet, I get an error:-

             

            WITH src AS (SELECT ROWNUM,LINE,TEXT,origin_con_id FROM SYS.Dba_SOURCE

            WHERE TYPE = 'PACKAGE BODY' AND OWNER = 'SSL' AND NAME = 'AP_HELP_DML')

            SELECT text FROM src, (SELECT max(origin_con_id) max_orig FROM src)

            WHERE origin_con_id = max_orig

            ORDER BY LINE

            Error report -

            ORA-12805: parallel query server died unexpectedly

             

            Is it possible that 17.3 is taking advantage of the parallel server architecture (and 4 didn't?) and this is a database initialisation parameter question?  Any pointers on configuration settings needed for SQL Developer?

             

            Thanks

             

            Paul  

            • 3. Re: Can not view package procedure or function body PL/SQL code
              PaulC

              Hi Jeff

               

              Given that the error in the SQL worksheet was ORA-12805: parallel query server died unexpectedly, I thought I ought to check the database logs.  There is a dump and trace file, as below.  The problem appears to be more than just configuration?  

               

              alert.log extract:-

               

              Thu Dec 21 18:58:53 2017

              Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FD200000001] [PC:0x5AA60E5, __intel_memset()+837] [flags: 0x0, count: 1]

              Errors in file /home/oracle/app/diag/rdbms/cdb1/cdb1/trace/cdb1_p001_7466.trc  (incident=1092215) (PDBNAME=DEV12):

              ORA-07445: exception encountered: core dump [__intel_memset()+837] [SIGSEGV] [ADDR:0x7FD200000001] [PC:0x5AA60E5] [Address not mapped to object] []

              Incident details in: /home/oracle/app/diag/rdbms/cdb1/cdb1/incident/incdir_1092215/cdb1_p001_7466_i1092215.trc

              Use ADRCI or Support Workbench to package the incident.

              See Note 411.1 at My Oracle Support for error and packaging details.

              Thu Dec 21 18:58:54 2017

              Dumping diagnostic data in directory=[cdmp_20171221185854], requested by (instance=1, osid=7466 (P001)), summary=[incident=1092215].

              Thu Dec 21 18:58:57 2017

              Sweep [inc][1092215]: completed

              Sweep [inc2][1092215]: completed

              Thu Dec 21 18:59:44 2017

              Errors in file /home/oracle/app/diag/rdbms/cdb1/cdb1/trace/cdb1_ora_6083.trc:

              ORA-12805: parallel query server died unexpectedly

               

              Trace file:-

               

              Trace file /home/oracle/app/diag/rdbms/cdb1/cdb1/trace/cdb1_ora_6083.trc

              Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

              With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

              ORACLE_HOME = /home/oracle/app/oracle/product/12.1.0/dbhome_1

              System name: Linux

              Node name: localhost.localdomain

              Release: 3.10.0-229.1.2.el7.x86_64

              Version: #1 SMP Thu Mar 26 09:10:51 PDT 2015

              Machine: x86_64

              Instance name: cdb1

              Redo thread mounted by this instance: 1

              Oracle process number: 44

              Unix process pid: 6083, image: oracle@localhost.localdomain

               

              *** 2017-12-21 18:59:44.465

              *** SESSION ID:(325.2858) 2017-12-21 18:59:44.465

              *** CLIENT ID:() 2017-12-21 18:59:44.465

              *** SERVICE NAME:(dev12.localdomain) 2017-12-21 18:59:44.465

              *** MODULE NAME:(SQL Developer) 2017-12-21 18:59:44.465

              *** CLIENT DRIVER:(jdbcthin) 2017-12-21 18:59:44.465

              *** ACTION NAME:() 2017-12-21 18:59:44.465

              *** CONTAINER ID:(3) 2017-12-21 18:59:44.465

               

              qerpxFetch

                      rwsrid:4 pxid:1 err:12805

              ----- Explain Plan Dump -----

              ----- Compact Format (Stream) -----

               

              Dumping stream from 0 to 371

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

               

              0000: 143 137  23   1   1   0  43   0   0   0   1   0   0   0   0 113  19   6  17   9    ......+........q....

              0020:   4  42   6   7  44  10 106 131 240 131 241 224 183  66  18  54 224 183  66  18    .*..,.j......B.6..B.

              0040: 131 245 131 243   2  38   3 129 204   0 131 243   4 131 243   5 131 243   6 131    .....&..............

              0060: 243   1 131 242   7 131 242   3 131 242   2  38   3 129 204   0   1   1   1   8    ...........&........

              0080:   1   1   1   9  37   1   2   1   8   1   9  19   1   1   9   2   4   4  10   1    ....%...............

              0100:   6   6   9   2   5   5  10   2   2   3  11   0   0 143 129  23   2   2   1  25    ....................

              0120:   0   0   0   2   0 143   7   3   3  15   0   0   0   0 143   7   4   4  89   0    ..................Y.

              0140:   0   0   0 143 193  32 100   5   5  88  89   1 225  64 150 180   0   1 136 120    ..... d..XY..@.....x

              0160: 131 232   4  12  13   0   0 143 193  48   4   6   6  93  52   1 225  64 150 180    .........0...]4..@..

              0180:   0   1 136 120  17   6   0   1 131 232   3   0 143 193  38 116   7   7  21  24    ...x..........&t....

              0200:   1 225  64 150 180   0   1 136 120 131 232   2   2  12  14   0   3  11   9 143    ..@.....x...........

              0220: 128 132   2   8   2  44  67   5 226  93 138  41   4   1 135 249   0 143 134  84    .....,C..].).......T

              0240:   3   9   2   0   4 185  71   4   1 135 249   0   0   0   0   0   0 143 134  20    ......G.............

              0260:   4  10  53   0   2 156 163   2   1  13   6   1   8   0 143  23   5  11  44  55    ..5...............,7

              0280:   1  13   6   0 143 134  20   6  12  53   0   2 156 163   2   1  13   5   6   9    .........5..........

              0300:   0 143 134 124   7  13  38  24   2 156 163   2   1 135 249   5  12  15 240 253    ...|..&.............

              0320: 157 102  52   5  10  10 143 134 148   4  14   2  53   0   2 156 163   2   1 135    .f4.........5.......

              0340: 236   4   1   9   0 143 134 124   5  15  38  24   2 156 163   2   1 135 249   4    .......|..&.........

              0360:  12  15 240 253 157 102  52   4  10  10 142                                        .....f4....

              End of dump for stream from 380 to 371

              ----- Plan Table -----

               

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

              Plan Table

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

              ----------------------------------------------------------------+-----------------------------------+-------------------------+---------------+

              | Id  | Operation                   | Name                      | Rows  | Bytes | Cost  | Time      |  TQ  |IN-OUT|PQ Distrib | Pstart| Pstop |

              ----------------------------------------------------------------+-----------------------------------+-------------------------+---------------+

              | 0   | SELECT STATEMENT            |                           |       |       |     6 |           |      |      |           |       |       |

              | 1   |  TEMP TABLE TRANSFORMATION  |                           |       |       |       |           |      |      |           |       |       |

              | 2   |   LOAD AS SELECT            |                           |       |       |       |           |      |      |           |       |       |

              | 3   |    COUNT                    |                           |       |       |       |           |      |      |           |       |       |

              | 4   |     PX COORDINATOR          |                           |       |       |       |           |      |      |           |       |       |

              | 5   |      PX SEND QC (RANDOM)    | :TQ10000                  |     1 |  2168 |     1 |  00:00:01 |:Q1000| P->S |QC (RANDOM)|       |       |

              | 6   |       PX PARTITION LIST ALL |                           |     1 |  2168 |     1 |  00:00:01 |:Q1000| PCWC |           | 1     | 2     |

              | 7   |        FIXED TABLE FULL     | X$COMVW$                  |     1 |  2168 |     1 |  00:00:01 |:Q1000| PCWP |           |       |       |

              | 8   |   SORT ORDER BY             |                           |     1 |  2041 |     5 |  00:00:01 |      |      |           |       |       |

              | 9   |    NESTED LOOPS             |                           |     1 |  2041 |     4 |  00:00:01 |      |      |           |       |       |

              | 10  |     VIEW                    |                           |     1 |    13 |     2 |  00:00:01 |      |      |           |       |       |

              | 11  |      SORT AGGREGATE         |                           |     1 |    13 |       |           |      |      |           |       |       |

              | 12  |       VIEW                  |                           |     1 |    13 |     2 |  00:00:01 |      |      |           |       |       |

              | 13  |        TABLE ACCESS FULL    | SYS_TEMP_0FD9D6634_2D8FA87|     1 |  2041 |     2 |  00:00:01 |      |      |           |       |       |

              | 14  |     VIEW                    |                           |     1 |  2028 |     2 |  00:00:01 |      |      |           |       |       |

              | 15  |      TABLE ACCESS FULL      | SYS_TEMP_0FD9D6634_2D8FA87|     1 |  2041 |     2 |  00:00:01 |      |      |           |       |       |

              ----------------------------------------------------------------+-----------------------------------+-------------------------+---------------+

              Predicate Information:

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

              7 - filter(("TYPE"='PACKAGE BODY' AND "OWNER"='SSL' AND "NAME"='AP_HELP_DML'))

              14 - filter("ORIGIN_CON_ID"="MAX_ORIG")

              Column Projection Information (identified by operation id):

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

              1 - "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000]

              2 - SYSDEF[4], SYSDEF[0], SYSDEF[1], SYSDEF[112], SYSDEF[0]

              3 - "OWNER"[VARCHAR2,128], "NAME"[VARCHAR2,128], "TYPE"[VARCHAR2,12], "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000], "ORIGIN_CON_ID"[NUMBER,22], ROWNUM[8]

              4 - "OWNER"[VARCHAR2,128], "NAME"[VARCHAR2,128], "TYPE"[VARCHAR2,12], "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000], "ORIGIN_CON_ID"[NUMBER,22]

              5 - (#keys=0) "OWNER"[VARCHAR2,128], "NAME"[VARCHAR2,128], "TYPE"[VARCHAR2,12], "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000], "ORIGIN_CON_ID"[NUMBER,22]

              6 - (rowset=16) "OWNER"[VARCHAR2,128], "NAME"[VARCHAR2,128], "TYPE"[VARCHAR2,12], "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000], "ORIGIN_CON_ID"[NUMBER,22]

              7 - (rowset=16) "OWNER"[VARCHAR2,128], "NAME"[VARCHAR2,128], "TYPE"[VARCHAR2,12], "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000], "ORIGIN_CON_ID"[NUMBER,22]

              8 - (#keys=1) "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000]

              9 - "MAX_ORIG"[NUMBER,22], "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000], "ORIGIN_CON_ID"[NUMBER,22]

              10 - "MAX_ORIG"[NUMBER,22]

              11 - (#keys=0) MAX("ORIGIN_CON_ID")[22]

              12 - "ORIGIN_CON_ID"[NUMBER,22]

              13 - "C0"[NUMBER,22], "C1"[NUMBER,22], "C2"[VARCHAR2,4000], "C3"[NUMBER,22]

              14 - "LINE"[NUMBER,22], "TEXT"[VARCHAR2,4000], "ORIGIN_CON_ID"[NUMBER,22]

              15 - "C0"[NUMBER,22], "C1"[NUMBER,22], "C2"[VARCHAR2,4000], "C3"[NUMBER,22]

               

              Content of other_xml column

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

              nodeid/pflags: 6 17  db_version     : 12.1.0.2

                parse_schema   : SSL

                plan_hash_full : 3641470511

                plan_hash      : 1386741252

                plan_hash_2    : 3641470511

                Outline Data:

                /*+

                  BEGIN_OUTLINE_DATA

                    IGNORE_OPTIM_EMBEDDED_HINTS

                    OPTIMIZER_FEATURES_ENABLE('12.1.0.2')

                    DB_VERSION('12.1.0.2')

                    ALL_ROWS

                    OUTLINE_LEAF(@"SEL$F5BB74E1")

                    MERGE(@"SEL$2")

                    OUTLINE_LEAF(@"SEL$AE95C8DF")

                    OUTLINE_LEAF(@"SEL$AE95C8E0")

                    OUTLINE_LEAF(@"SEL$4")

                    OUTLINE_LEAF(@"SEL$3")

                    OUTLINE(@"SEL$1")

                    OUTLINE(@"SEL$2")

                    OUTLINE(@"SEL$F5BB74E1")

                    MERGE(@"SEL$2")

                    NO_ACCESS(@"SEL$3" "from$_subquery$_003"@"SEL$3")

                    NO_ACCESS(@"SEL$3" "SRC"@"SEL$3")

                    LEADING(@"SEL$3" "from$_subquery$_003"@"SEL$3" "SRC"@"SEL$3")

                    USE_NL(@"SEL$3" "SRC"@"SEL$3")

                    FULL(@"SEL$AE95C8DF" "T1"@"SEL$AE95C8DF")

                    NO_ACCESS(@"SEL$4" "SRC"@"SEL$4")

                    FULL(@"SEL$AE95C8E0" "T1"@"SEL$AE95C8E0")

                    FULL(@"SEL$F5BB74E1" "INT$DBA_SOURCE"@"SEL$2")

                  END_OUTLINE_DATA

                */

               

              Process received 12805 signal due to P001

              ORA-12805: parallel query server died unexpectedly

              Dump of memory from 0x0000000109A526C8 to 0x0000000109A527D0

              109A526C0                   48544957 63727320          [WITH src]

              109A526D0 20534120 4C455328 20544345 4E574F52  [ AS (SELECT ROWN]

              109A526E0 4C2C4D55 2C454E49 54584554 69726F2C  [UM,LINE,TEXT,ori]

              109A526F0 5F6E6967 5F6E6F63 46206469 204D4F52  [gin_con_id FROM ]

              109A52700 2E535953 5F616244 52554F53 0A204543  [SYS.Dba_SOURCE .]

              109A52710 45485709 54204552 20455059 5027203D  [.WHERE TYPE = 'P]

              109A52720 414B4341 42204547 2759444F 444E4120  [ACKAGE BODY' AND]

              109A52730 4E574F20 3D205245 53532720 4120274C  [ OWNER = 'SSL' A]

              109A52740 4E20444E 20454D41 4127203D 45485F50  [ND NAME = 'AP_HE]

              109A52750 445F504C 29274C4D 4553090A 5443454C  [LP_DML')..SELECT]

              109A52760 78657420 52462074 73204D4F 202C6372  [ text FROM src, ]

              109A52770 4C455328 20544345 2878616D 6769726F  [(SELECT max(orig]

              109A52780 635F6E69 695F6E6F 6D202964 6F5F7861  [in_con_id) max_o]

              109A52790 20676972 4D4F5246 63727320 0A202029  [rig FROM src)  .]

              109A527A0 45485709 6F204552 69676972 6F635F6E  [.WHERE origin_co]

              109A527B0 64695F6E 6D203D20 6F5F7861 20676972  [n_id = max_orig ]

              109A527C0 524F090A 20524544 4C205942 00454E49  [..ORDER BY LINE.]

              • 4. Re: Can not view package procedure or function body PL/SQL code

                Service Request:  Unfortunately not, company has a policy of raising service requests for production sites only

                Then have someone reproduce the problem on a 'production site' and then submit an SR.

                 

                If they won't do that then your company has decided that whether your tool works the way you want or not is NOT a priority for them.

                • 5. Re: Can not view package procedure or function body PL/SQL code
                  thatJeffSmith-Oracle

                  you're getting database issues, we're just asking for data...I think you need to get a DBA to look into this

                  • 6. Re: Can not view package procedure or function body PL/SQL code
                    PaulC

                    Hi Jeff

                     

                    Yes, you are right; it's also database specific.  Will pass over to DBA's.  Thanks for looking.

                     

                    Paul