Calling an Oracle stored procedure with blob parameters

Hi,

I am trying to migrate a ColdFusion 8 application to Lucee. This
application talks to an Oracle database and uses CFSTOREDPROC to call
stored procedures. Unfortunately, due to
https://luceeserver.atlassian.net/browse/LDEV-637 (cfstoredproc fails when
calling a procedure with parameters on Oracle with a specified schema), I
can not currently find a way to make this application run on Lucee.

The crux of the problem is that we cannot use cfstoredproc to call our
stored procedures on Lucee. In other situations, we’ve been able to work
around this by using CFQUERY and the call statement. So for example, the
following code would replace our CFSTOREDPROC code:

<cfquery …>
call myschema.mypackage.myprocedure(

)

However, we need to pass blob parameters (cfsqltype=“CF_SQL_BLOB”) to our
stored procedure, and you cannot do this using CFQUERY as above. Attempting
to do so gets the error "“long (>4k) parameters are only allowed in the
values list of simple insert/update statements”.

Can anyone suggest any other way to workaround this problem and get our
application working on Lucee?

For reference, a similar discussion took place
in https://groups.google.com/d/topic/lucee/H22AKjWeDb8/discussion but no
solution to the underlying bug was found at that time.

Thanks,

Max Spicer

Hi Max,

we have the same issues with Lucee & Oracle.
I am in contact with the Lucee Team and created an environment for them to test and reproduce the issue.
So I hope it will be resolved soon.

Cheers,
HarryVon: lucee@googlegroups.com [mailto:lucee@googlegroups.com] Im Auftrag von Max Spicer
Gesendet: Mittwoch, 25. November 2015 14:11
An: Lucee lucee@googlegroups.com
Betreff: [Lucee] Calling an Oracle stored procedure with blob parameters

Hi,

I am trying to migrate a ColdFusion 8 application to Lucee. This application talks to an Oracle database and uses CFSTOREDPROC to call stored procedures. Unfortunately, due to https://luceeserver.atlassian.net/browse/LDEV-637 (cfstoredproc fails when calling a procedure with parameters on Oracle with a specified schema), I can not currently find a way to make this application run on Lucee.

The crux of the problem is that we cannot use cfstoredproc to call our stored procedures on Lucee. In other situations, we’ve been able to work around this by using CFQUERY and the call statement. So for example, the following code would replace our CFSTOREDPROC code:

<cfquery …>
call myschema.mypackage.myprocedure(

)

However, we need to pass blob parameters (cfsqltype=“CF_SQL_BLOB”) to our stored procedure, and you cannot do this using CFQUERY as above. Attempting to do so gets the error "“long (>4k) parameters are only allowed in the values list of simple insert/update statements”.

Can anyone suggest any other way to workaround this problem and get our application working on Lucee?

For reference, a similar discussion took place in https://groups.google.com/d/topic/lucee/H22AKjWeDb8/discussion but no solution to the underlying bug was found at that time.

Thanks,

Max Spicer


Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html

You received this message because you are subscribed to the Google Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.commailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.commailto:lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/341802f9-3aed-4f43-a1d4-7a28da1012de%40googlegroups.comhttps://groups.google.com/d/msgid/lucee/341802f9-3aed-4f43-a1d4-7a28da1012de%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.