Re: Invalid Cursor (corrected)

On Nov 14, 4:44 pm, Georg Scholz <georgsch..._at_gmail.com> wrote:
> 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:
> a) The proc returning the ref cursor contains a SELECT statement
> with 300+ lines
> b) I cannot post from my clients - it is confidential.
>
> Best regards
> Georg

How about creating a Temporary table and populating it with values from the procedure and open a cursor on the TEMPORARY Table from the local system?

Thanks

www.ramsora.blogspot.com Received on Thu Nov 15 2007 - 08:08:59 CST