Cfstoredproc fails when calling a procedure with parameters on Oracle

dev support
1

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#
2

looks like it might be related to [LDEV-2386] - Lucee?

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

4

Thanks for a quick reply. I have raised a bug - [LDEV-3170] - Lucee

1 Like
5

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

Thank you.

6

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