testing oracle package

Hi

Currently trying to test my oracle package Fleet.SELECT_CARAPPLICATIONBYQUOTE
 which accepts the following SELECT_CARAPPLICATIONBYQUOTE(stringtype, Cursortype)

The problem i have is, i use the following syntax to (try to) test it. and i know i need to declare a cursor type but i just cannot solve it and there for am unable to test my proc.

Any Clues would be greatly appreciated.

regards

Robin

--Test Call --

BEGIN
         fleet_pkg.SELECT_CARAPPLICATIONBYQUOTE('13456',robinCur); END;
----Package Code as follows ---

CREATE OR REPLACE PACKAGE FLEET_PKG
AS
TYPE car_appCur IS REF CURSOR;

PROCEDURE Select_CarApplicationByQuote(in_quoteref IN VARCHAR2, app_cursor IN OUT car_appCur );

PROCEDURE Select_CarApplicationByQuote(in_quoteref IN VARCHAR2, app_cursor IN OUT car_appCur ) IS
BEGIN
Open app_cursor FOR

		 SELECT ID,FK_EMPLOYEE_ID, APPLICATION_DATE, ACTIVE, SIGNED_OFF,
		 		SIGNOFF_DATE, REQUIRED_DATE, MONTHLY_COST, AVCQUOTE_REF

FROM EMPLOYEE_CAR_APPLICATION
WHERE AVCQUOTE_REF = in_quoteref;

END Select_CarApplicationByQuote; Received on Wed Jan 29 2003 - 07:53:23 CST