Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Cfstoredproc fails when calling a procedure with parameters on Oracle

Description

If cfstoredproc is used to call a procedure with parameters within an Oracle package, it fails with below error message:

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to ‘TESTPROC’ ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Please help in resolving this issue.

Thank you.

Environment

Lucee version: 5.3.6.61

DatabaseName: Oracle
DatabaseVersion: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
DriverName: Oracle JDBC driver
DriverVersion: 12.1.0.2.0

Attachments

2
  • 02 Dec 2020, 03:42 pm
  • 02 Dec 2020, 03:42 pm

Activity

Show:

Pothys - MitrahSoft 27 April 2022 at 15:04
Edited

I've checked this ticket with oracle database 10g, and oracle extension 12.1.0.2.0 in lucee latest version 5.3.9.132-SNAPSHOT. when calling a procedure with/without parameters to Oracle lucee throws an error like ORA-00904: "PROC"."OBJECT_ID": invalid identifier. Seems both with/without parameters work fine in ACF.

lucee.runtime.exp.DatabaseException: ORA-00904: "PROC"."OBJECT_ID": invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) at lucee.runtime.tag.StoredProc.createReturnValue(StoredProc.java:358) at lucee.runtime.tag.StoredProc.doEndTag(StoredProc.java:561) at test.testcases.ldev3170.test_cfm$cf$5.call(/test/testcases/LDEV3170/test.cfm:29) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1043) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:935)

Dvpr Forever 16 December 2020 at 14:06

Please let me know if there is any progress in fixing this issue.

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Affects versions

Created 2 December 2020 at 15:45
Updated 1 July 2023 at 15:37

Flag notifications