Re: Invalid Cursor (corrected)

On Nov 14, 3:50 pm, vitalis..._at_gmail.com (Jerome Vitalis) wrote:
> Georg Scholz wrote:
> > Everything is compiling fine. The cursor is open. The variables have
> > correct types.
> > But still I am getting a runtime error "Invalid cursor" in the line
> > marked above. What am I doing wrong?
>
> 1) You should post your *actual* code. There is still at least one typo in
> the code you posted.
>
> 2) You cannot return a ref cursor over a database link, so the result you
> get does not look surprising.
> -----
> échangez opinions et commentaires dans les forums de discussion.http://www.usenetgratuit.com/

Thank you!!

ad 2) : So is there any other way to get a cursor from a linked database?

ad 1): I cannot post the the actual code for two reaseons:

1. The proc returning the ref cursor contains a SELECT statement with 300+ lines
2. I cannot post from my clients - it is confidential.

Best regards
Georg Received on Wed Nov 14 2007 - 10:44:34 CST