Hello,

How can I execute Oracle Stored Procedure in CF if I don't want to provide all
parameters for that SP.
The reason is very simple: SP in Oracle can have some input parameters with
default values - so I want to use default value, but in order to use default
value, I must not provide particular parameter in a SP call...

I think it couldn't be done with 'cfstoredproc' tag as long as it doesn't
support naming parameters for Oracle in CF MX.

The only other solution is to use 'cfquery' tag. The only problem in this case
is how to return the value in a query (if SP has an output parameter). In
Oracle SP must be executed in a DECLARE-BEGIN-END block, which, as far as I
know, cannot return a query. In MS SQL I could do something like this: EXEC
sp... SELECT return_value AS some_name - and it will return a query with output
parameter in it.

So, how can I do something like this in Oracle?

Thanks for any information!