Ref cursor in stored proc

singular_droid · **Joined:** Thu Apr 14, 2005 8:21 am **Posts:** 5

Can I map the oracle stored proc with ref cursor as one of it's parameters? something like this:

Code:

procedure a(v in number, i in number, l out number, c out ref cursor )
is
begin
 ...
  open c for
    select a1,a2,a3,a4 from ...
 ...
end

max · **Posted:** Thu Apr 14, 2005 12:46 pm

no out parameters is not supported - it should be the return value.

I would assume you could solve that issue by simply wrapping it and return the out parameter.

singular_droid · **Joined:** Thu Apr 14, 2005 8:21 am **Posts:** 5

hmmm. This is the problem. There are a lot of stored proc with multiple out parameters. And i have no idea how to write a function with multiple returns))). The only way is refactoring of SQL(but this can take a lot of time - problem too), isn't it?

max · **Posted:** Mon Apr 18, 2005 7:09 am

yes I know its tricky, but since it require us to access the statement to get the values it is not possible at the moment.

I've never really understood why out parameters are done on the statement and not the resultset...its a nice mismatch ,)

/max