-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|