ORDER BY error?

I have the following code which I am running through server side javascript. Everything was working well until I added a ORDER BY lastname statement at the end of my query. Now, when I execute this procedure, I am delivered to a blank page rather than a page displaying the results. Does anybody know why this is happening?

Here is the code:



CREATE OR REPLACE
PACKAGE pkg_claim_service

IS
cert_no_var VARCHAR2(9);
e_mail_var VARCHAR2(50);
pat_lastname_var varchar2(17);
pat_firstname_var varchar2(10);


/**********************************************************/
/************** Output Record And Cursor******************/
/********************************************************/

CURSOR output_cur IS
SELECT
e_mail_var,
pat_firstname_var,
pat_lastname_var
FROM
ops_arw.member_pin ME,
ops_arw.subscriber SU,
ops_arw.int_med_claim_summary INT;

TYPE ref_cur IS REF CURSOR return output_cur%ROWTYPE;

/***********************************************/
/*********** END of Cursors *******************/
/*********************************************/



PROCEDURE FIND_USERS
(
output_cur OUT ref_cur
);

END pkg_claim_service;
/

--------------------------------------
--------Package Body------------------
--------------------------------------

CREATE OR REPLACE
PACKAGE BODY pkg_claim_service
IS

PROCEDURE FIND_USERS
(
output_cur OUT ref_cur
)

IS
NOW DATE;
BEFORE DATE;

BEGIN

NOW := SYSDATE;
BEFORE := NOW - 7;


OPEN output_cur FOR
SELECT
ME.e_mail,
su.pat_firstname lastname,
su.pat_lastname
FROM
ops_arw.member_pin ME,
ops_arw.subscriber SU,
ops_arw.int_med_claim_summary INT
WHERE
ME.SRV_EMAIL_PREFERENCE = 'Y' AND
ME.CERT_NO = SU.CERT_NO AND
ME.CERT_NO = INT.CERT_NO AND
TO_CHAR(TO_DATE(SU.MEM_DOB, 'YYYYMMDD'), 'YYYYMM') = TO_CHAR(ME.MEM_DOB, 'YYYYMM') AND
INT.INSERT_DATE >= BEFORE
ORDER BY
lastname;



end FIND_USERS;

END pkg_claim_service;


/
show errors

Any help is appreciated

Have you tried running the code in a sqlplus window?

Maybe the sort is taking so long that you are getting a timeout somwhere ?