in reply to Re: 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?

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.
  • Comment on Re: Re: Re: Re: How I can get the returned cursor from database in PERL program?

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: How I can get the returned cursor from database in PERL program?
by rdfield (Priest) on Mar 11, 2002 at 11:38 UTC
    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

      Dear rdfield, Atlast i succeeded by following the points u told. Thkz a lot for the timely help. Cheers, Narayan