See I think I have scenrio 1 and 2 of your reply covered...
I do think I should mention that Perhaps that the open cursor is using a weakly typed ref cursor and that the report is using a strongly typed ref cursor. I'm not sure how or if I can get around this.
Thanks, Brian
OK, well I have the below package in my Oracle Report...
PACKAGE pkg_test IS
type rec_test
is record
( client_name client.client_name%type
, last_name client.last_name%type
, date_of_birth client.date_of_birth%type );
type rc_test is REF CURSOR return rec_test;
END;
next I'm...
Has anyone see this error and what could possibly be the solution? I am getting this when I run the report in the reports wizard, after I select a layout, fields, template etc.
REP-0065: Virtual Memory System error.
REP-0200: Cannot allocate enough memory.
cavaa22
Another window...
REP-0619...
Is it possible to call and Oracle stored procedure or programming unit from an Oracle Report? If so, what is that syntax to make this call to the procedure. My situation is that I need to send in two params to the Oracle Report and then pass those to a stored proc for a list of data. Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.