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.

Details below:

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

Oracle Procedure:

CREATE OR REPLACE package lucee_bug_test as
PROCEDURE testproc;
PROCEDURE testproc2(p1 varchar2);
end;
/

CREATE OR REPLACE package body lucee_bug_test as
PROCEDURE testproc IS
BEGIN
NULL;
END;
procedure testproc2(p1 varchar2) is
begin
null;
end;
END;
/

CFML programs:

test_cfstoredproc.cfm:

schema is #dsUser#

calling lucee_bug_test.testproc:


#cfcatch.detail#

calling #dsUser#.lucee_bug_test.testproc:


#cfcatch.detail#

calling lucee_bug_test.testproc2(‘foo’):




#cfcatch.detail#

calling #dsUser#.lucee_bug_test.testproc2(‘foo’):




#cfcatch.detail#

looks like it might be related to https://luceeserver.atlassian.net/browse/LDEV-2386?

can you file a new bug and link it back to that one?

Thanks for a quick reply. I have raised a bug - https://luceeserver.atlassian.net/browse/LDEV-3170

1 Like

There is no response to the bug raised.
Please let me know whom to contact to get this issue fixed.

Thank you.

if your business needs to prioritise this fix, you could sponsor someone to address it