in reply to Re: Re: How I can get the returned cursor from database in PERL program?
in thread How I can get the returned cursor from database in PERL program?

In the PL/SQL you issue a CLOSE CURSOR command. Oops. If you pass back a closed cursor you're not going to get any data - you can't FETCH from a closed cursor...it's like trying to read from a closed file.

rdfield

Replies are listed 'Best First'.
Re: Re: Re: Re: How I can get the returned cursor from database in PERL program?
by Anonymous Monk on Mar 11, 2002 at 10:45 UTC
    I've tried returning without closing the cursor in the PL/SQL block also, but still i get the same old error. Can i get some other suggestions to resolve this problem??
[reply]
      OK. How about...you've got a colon after the BEGIN in your prepare statement instead of whitespace?

      rdfield

[reply]
Re: Re: Re: Re: How I can get the returned cursor from database in PERL program?
by Anonymous Monk on Mar 11, 2002 at 11:33 UTC
    I've also tried returning without closing the cursor in PL/SQL block, but still i get the same old error. Any other suggestions to resolve this problem will be of great help. Thanks a lot.
[reply]
      Please see my previous replies:
    • Remove the CLOSE CURSOR from your PL/SQL
    • Remove the colon from the anonymous PL/SQL that you use to call the procedure in the package that is just after the BEGIN and replace it with a space. Everything else is OK

      rdfield

[reply]
[d/l]
[select]
        Dear rdfield,

Atlast i succeeded by following the points u told. Thkz a 
lot for the timely help.

Cheers,
Narayan

        [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom