Oracle GetSchema() not returning package procedures
<p>I'm using GetSchema to load a list of procedures from my Oracle environment,  however I only see root procedures, no package procedures.  Looking through the documentation though, I don't see how else they could be returned.  Does anyone know if there is a filter/restriction to get package procs, or should I be calling a different object type?</p>

<pre><code>Dim ObjectType= "Procedures"
Dim Options As String()

Dim ObjectsTable = OracleConnection.GetSchema(ObjectType, Options)
</code></pre>

<p><strong>Sample 'Packages' Results</strong></p>

<pre><code>?RefinedPackageSchemaData(10)
Count = 12
    (0): {[OWNER, #REDACTED SCHEMA NAME#]}
    (1): {[OBJECT_NAME, #REDACTED PACKAGE NAME#]}
    (2): {[SUBOBJECT_NAME, ]}
    (3): {[OBJECT_ID, 130652]}
    (4): {[DATA_OBJECT_ID, ]}
    (5): {[LAST_DDL_TIME, 4/27/2015 3:52:26 PM]}
    (6): {[TIMESTAMP, 2015-04-27:15:52:26]}
    (7): {[STATUS, VALID]}
    (8): {[TEMPORARY, N]}
    (9): {[GENERATED, N]}
    (10): {[SECONDARY, N]}
    (11): {[CREATED, 1/9/2015 9:47:50 AM]}
</code></pre>

<p>The number of rows corresponds to exactly the number of packages, not package+procedure combinations</p>

<p><strong>Sample 'PackageBodies' Result</strong></p>

<pre><code> ?RefinedPackageBodySchemaData(10)
    Count = 12
        (0): {[OWNER, #REDACTED SCHEMA NAME#]}
        (1): {[OBJECT_NAME, #REDACTED PACKAGE NAME#]}
        (2): {[SUBOBJECT_NAME, ]}
        (3): {[OBJECT_ID, 130653]}
        (4): {[DATA_OBJECT_ID, ]}
        (5): {[LAST_DDL_TIME, 4/27/2015 4:19:44 PM]}
        (6): {[TIMESTAMP, 2015-04-27:16:19:44]}
        (7): {[STATUS, VALID]}
        (8): {[TEMPORARY, N]}
        (9): {[GENERATED, N]}
        (10): {[SECONDARY, N]}
        (11): {[CREATED, 1/9/2015 9:48:02 AM]}
</code></pre>

<p>The number of rows corresponds to exactly the number of packages, not package+procedure combinations</p>

<p><a href="https://msdn.microsoft.com/en-us/library/cc716723(v=vs.110).aspx" rel="nofollow">MSDN Oracle GetSchema Reference</a></p>