Calling an Oracle stored procedure with blob parameters

[Max Spicer]

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(

    <cfqueryparam value="param1value" cfsqltype="CF_SQL_VARCHAR">

  )

</cfquery>

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

 

[Harry Klein]

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,

Harry

--
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+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/341802f9-3aed-4f43-a1d4-7a28da1012de%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Max Spicer]

Hi,

Thanks for the information. Is there already an open bug for your issue? I opened https://luceeserver.atlassian.net/browse/LDEV-637 myself as I couldn't find anything relevant. I'll update it if it turns out to be a duplicate.

Cheers,

Max

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/F5A941E045A6FE4288ABB2E3D797146FA7457900%40SRV-DC1.contens.local.

[Harry Klein]

Hi,

 

yes, I hope it is the same issue:

https://luceeserver.atlassian.net/browse/LDEV-413

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CABbdpz9_qynRfD8TS1qRj_yXeZSs%2BReiC9D9fRiN0KrE9syCxA%40mail.gmail.com.

[Max Spicer]

Hi,

That might be related, but the error returned is different. I'll add a link to each issue.

Cheers,

Max

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/F5A941E045A6FE4288ABB2E3D797146FA74579C2%40SRV-DC1.contens.local.