[teiid-issues] [JBoss JIRA] (TEIID-3870) Add ability to properly qualify package objects

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-3870:
----------------------------------
    Description: 
Even if the catalog name pattern matches package names, there is no option or recognition that contained procedures should be qualified as <package / catalog>.<name>.

We need this because at least in Oracle, procedures may be encapsulated in Oracle Packages that are used as catalog names in the DatabaseMetaData.  When trying to import these into Teiid, the "Name in Source" field does not allow me to specify the Package name, so I can't call those procedures.

  was:
Add ability to fully qualify a database object's (tables/views/procedures/etc) "Name in Source" field with its package/catalog name.

We need this because at least in Oracle, procedures may be encapsulated in Oracle Packages.  When trying to import these into Teiid, the "Name in Source" field does not allow me to specify the Package name, so I can't call those procedures.

        Summary: Add ability to properly qualify package objects  (was: Add ability to fully qualify an object with its package/catalog name)


> Add ability to properly qualify package objects
> -----------------------------------------------
>
>                 Key: TEIID-3870
>                 URL: https://issues.jboss.org/browse/TEIID-3870
>             Project: Teiid
>          Issue Type: Feature Request
>    Affects Versions: 8.7.1.6_2
>         Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
>            Reporter: Steve Tran
>            Assignee: Steven Hawkins
>             Fix For: 8.12.4
>
>
> Even if the catalog name pattern matches package names, there is no option or recognition that contained procedures should be qualified as <package / catalog>.<name>.
> We need this because at least in Oracle, procedures may be encapsulated in Oracle Packages that are used as catalog names in the DatabaseMetaData.  When trying to import these into Teiid, the "Name in Source" field does not allow me to specify the Package name, so I can't call those procedures.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)