Oracle Wrong schema detection

Description

When executing the procedure through the CFSTOREDPROC tag, the specified scheme is ignored and the procedure symmetric is determined by the first record from the SQL query. Which can lead to a change in the types of parameters and to an execution error ORA-06550: line 1, column 7: PLS-00306

lucee.runtime.tag.StoredProc#returnValue knows about the specified scheme, but does not use it in a SQL query or when filtering the result

Environment

None

Activity

Pothys - MitrahSoft 
2 December 2024 at 14:04

, I have investigated this ticket with Lucee version 6.2.0.169-SNAPSHOT and Oracle. When I tried executing the procedure through the <CFSTOREDPROC> tag, I did not encounter any issues. Therefore, I am going to close the ticket. If the issue occurs in any scenario, we can reopen the ticket.

Pothys - MitrahSoft 
28 June 2024 at 13:22
(edited)

It seems to be fixed. Could you please check this with Lucee latest version and report back here?,It will improve the status of this ticket.

Zac Spitzer 
14 May 2021 at 11:56

this should be working as of version 5.3.4.8 as per the linked tasks?

Pothys - MitrahSoft 
21 July 2020 at 15:50

, Did you see my above comments? Please check and share here that.If possible.

Pothys - MitrahSoft 
1 April 2020 at 12:02

, Could you please share any test cases for this? Then only, we could find an exact error. So, it'll improve the status of the ticket.

Cannot Reproduce

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

Affects versions

Created 18 June 2019 at 15:27
Updated 2 December 2024 at 14:05
Resolved 2 December 2024 at 14:05