DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora 1001 ora 1000

  1. #1
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    I have a procedure here which takes refcursor parameter in and out. The only thing the proc. does is
    declare open refcursor for select.. end
    This works fine when I run the procedure in oracle, but when the developers run it in crystal reports it fails with ora 1001 errors and it displays ora 1000 also but there is no quesion of cursors exceeding as there are only around 30 cursors open and the open_cursors is set to 1500.

    What could be the reason for this error in crystal reports does it have its own maxopencursors parameter.
    KN

  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    problem solved there was a problem with a package defining the refcursor..
    KN

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width