How in ColdFusion with in variables get a Oracle stored procedure to return values?

Question

We have tried several things, we can get a stored procedure to return a result set if we are not passing in variables but we cannot get them when we are passing in variables.

We know how to do it calling MS SQL.

Thanks for any help,

Nathan Sr

P.S. we have heard this may not be possible with the current Oracle Driver is there a different Oracle driver?

Adam Cameron. · Answer

I can only barely understand what you're asking here (not from a technical perspective, but from understanding your written English), but I suspect you're wanting to know how to pass back values other than recordsets from Oracle?

You should be able to pass them back via a type=out proc param, shouldn't you?

If you could reword your post so it's a bit more coherent, and possibly post some code, that might help.

--

Adam

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded