[teiid-issues] [JBoss JIRA] Commented: (TEIID-1605) Unable to call a function that is defined within a package in oracle

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604293#comment-12604293 ] 

Steven Hawkins commented on TEIID-1605:
---------------------------------------

Translators currently make the assumption that pushdown function names do not contain a separator character.  We would have to relax that assumption to make this use case work automatically.

If you use Teiid Designer 7.4 you should be able to use a function name that is "package.function" in Teiid.  Note that prior to Teiid 7.1/Teiid Designer 7.4 it was never allowed to have a multi-part function name.  The translator can then be updated to modify all or just select functions by using their full metadata name - or you can just as easily hard code the proper name.

> Unable to call a function that is defined within a package in oracle
> --------------------------------------------------------------------
>
>                 Key: TEIID-1605
>                 URL: https://issues.jboss.org/browse/TEIID-1605
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 7.1.1
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>
> Unable to call a function that is defined within a package in oracle.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira