var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Crystal reports and Oracle result sets
I want to call oracle stored procedures using crystal reports and would appreciate any feedback on which of the various methods of returning result sets are best practice.
Having found a few methods the most straightforward seemed to be
CREATE OR REPLACE PROCEDURE TA_DEV.Test_Procedure (
Test_Cursor IN OUT Test_Package.Test_Type)
OPEN Test_Cursor FOR
In Sybase I can use select * to set the result set. Is there anything similar in Oracle?
If I go with the above method when does the cursor close if it is not explicitly closed at the end of the procedure
Result set from Oracle
Create or replace Function TESTSP RETURN SYS_REFCURSOR
open p_cur_user for
SELECT * FROM USERACCOUNTS;
thanks. Is there any downside to the fact that the cursor is not closed? Does it close when the calling crystal report is closed or when the procedure has finished returning the result set?
No there is no downside of the cursor. The oracle internally handles this.