"no function with name 'somefunction' exists in this scope" error in EDS

Solution Verified - Updated -

Issue

  • We want to expose a stored procedure in Oracle datasource but getting the error.
2014-08-21 11:41:49,644 WARN  [org.teiid.CONNECTOR] (Worker48_QueryProcessorQueue432) Connector worker process failed for atomic-request=OW7qAAhW0fct.3.1.52
org.teiid.translator.TranslatorException: Error Code:65000 Message:'{ ?= call somefunction(?,?,?,?,?,?)}' error executing statement(s): {1}
        at org.teiid.translator.jdbc.JDBCProcedureExecution.execute(JDBCProcedureExecution.java:70)
        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:276)
        at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)
        at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:143)
        at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:140)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:121)
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:245)
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00222: no function with name 'somefuntion' exists in this scope
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In