[JBoss JIRA] Created: (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures
7:07 p.m.
Support calling oracle stored functions returning result sets as stored procedures
----------------------------------------------------------------------------------
Key: TEIID-832
URL: https://jira.jboss.org/jira/browse/TEIID-832
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Minor
Fix For: 6.3.0
This is only an issue with oracle native drivers, which need to have the returned result
set explicitly called as a return parameter. For this to work we'll need to ensure
that the import metadata on a procedure is being set to isFunction appropriately and then
use that metadata in the Oracle connector.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:09 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures
[
https://jira.jboss.org/jira/browse/TEIID-832?page=com.atlassian.jira.plug...
]
Steven Hawkins updated TEIID-832:
---------------------------------
To workaround this issue, either use DataDirect drivers or create a stored procedure
wrapper to call the stored function.
Support calling oracle stored functions returning result sets as
stored procedures
----------------------------------------------------------------------------------
Key: TEIID-832
URL: https://jira.jboss.org/jira/browse/TEIID-832
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Minor
Fix For: 6.3.0
This is only an issue with oracle native drivers, which need to have the returned result
set explicitly called as a return parameter. For this to work we'll need to ensure
that the import metadata on a procedure is being set to isFunction appropriately and then
use that metadata in the Oracle connector.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:19 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures
[
https://jira.jboss.org/jira/browse/TEIID-832?page=com.atlassian.jira.plug...
]
Steven Hawkins updated TEIID-832:
---------------------------------
Fix Version/s: 7.0
(was: 6.3.0)
Support calling oracle stored functions returning result sets as
stored procedures
----------------------------------------------------------------------------------
Key: TEIID-832
URL: https://jira.jboss.org/jira/browse/TEIID-832
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Minor
Fix For: 7.0
This is only an issue with oracle native drivers, which need to have the returned result
set explicitly called as a return parameter. For this to work we'll need to ensure
that the import metadata on a procedure is being set to isFunction appropriately and then
use that metadata in the Oracle connector.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:47 p.m.
New subject: [JBoss JIRA] (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures
[
https://issues.jboss.org/browse/TEIID-832?page=com.atlassian.jira.plugin....
]
Van Halbert updated TEIID-832:
------------------------------
Fix Version/s: 7.6
(was: 8.0)
Support calling oracle stored functions returning result sets as
stored procedures
----------------------------------------------------------------------------------
Key: TEIID-832
URL: https://issues.jboss.org/browse/TEIID-832
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Minor
Fix For: 7.6
This is only an issue with oracle native drivers, which need to have the returned result
set explicitly called as a return parameter. For this to work we'll need to ensure
that the import metadata on a procedure is being set to isFunction appropriately and then
use that metadata in the Oracle connector.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:11 p.m.
New subject: [JBoss JIRA] (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures
[
https://issues.jboss.org/browse/TEIID-832?page=com.atlassian.jira.plugin....
]
Steven Hawkins updated TEIID-832:
---------------------------------
Issue Type: Quality Risk (was: Feature Request)
Priority: Major (was: Minor)
Changing to a major quality risk. Without this support we would need even more handling
for oracle stored procedures that have out parameter result sets.
Support calling oracle stored functions returning result sets as
stored procedures
----------------------------------------------------------------------------------
Key: TEIID-832
URL: https://issues.jboss.org/browse/TEIID-832
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.6
This is only an issue with oracle native drivers, which need to have the returned result
set explicitly called as a return parameter. For this to work we'll need to ensure
that the import metadata on a procedure is being set to isFunction appropriately and then
use that metadata in the Oracle connector.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:03 p.m.
New subject: [JBoss JIRA] (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures
[
https://issues.jboss.org/browse/TEIID-832?page=com.atlassian.jira.plugin....
]
Steven Hawkins updated TEIID-832:
---------------------------------
Description: This is only an issue with oracle native drivers, which need to have the
returned result set explicitly called as a return parameter. (was: This is only an issue
with oracle native drivers, which need to have the returned result set explicitly called
as a return parameter. For this to work we'll need to ensure that the import metadata
on a procedure is being set to isFunction appropriately and then use that metadata in the
Oracle connector. )
Affects: Documentation (Ref Guide, User Guide, etc.) (was: Release Notes)
Changed the description. isFunction now indicates that we will treat the procedure as a
scalar function, which is not applicable here. Some of this may be revisited when we have
a well-defined cursor type.
Support calling oracle stored functions returning result sets as
stored procedures
----------------------------------------------------------------------------------
Key: TEIID-832
URL: https://issues.jboss.org/browse/TEIID-832
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.6
This is only an issue with oracle native drivers, which need to have the returned result
set explicitly called as a return parameter.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:05 p.m.
New subject: [JBoss JIRA] (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures
[
https://issues.jboss.org/browse/TEIID-832?page=com.atlassian.jira.plugin....
]
Steven Hawkins resolved TEIID-832.
----------------------------------
Resolution: Done
Added the appropriate handling to the OracleExecutionFactory. Added an execution property
to revert to the old, non-oracle specific handling.
Support calling oracle stored functions returning result sets as
stored procedures
----------------------------------------------------------------------------------
Key: TEIID-832
URL: https://issues.jboss.org/browse/TEIID-832
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.6
This is only an issue with oracle native drivers, which need to have the returned result
set explicitly called as a return parameter.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:24 p.m.
New subject: [JBoss JIRA] (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures
[
https://issues.jboss.org/browse/TEIID-832?page=com.atlassian.jira.plugin....
]
Steven Hawkins closed TEIID-832.
--------------------------------
Support calling oracle stored functions returning result sets as
stored procedures
----------------------------------------------------------------------------------
Key: TEIID-832
URL: https://issues.jboss.org/browse/TEIID-832
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 7.6
This is only an issue with oracle native drivers, which need to have the returned result
set explicitly called as a return parameter.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4537
days inactive
5342
days old
7 comments
5 participants
participants (5)
-
Steven Hawkins (Closed) (JIRA) -
Steven Hawkins (JIRA)
-
Steven Hawkins (Resolved) (JIRA)
-
Steven Hawkins (Updated) (JIRA)
-
Van Halbert (Updated) (JIRA)