Stored Procedure complilation errors using the "With" statement.

  I’m having some syntax issues turning functioning and tested code into a SP.  Can I use the “with” statement and the variables as coded below in a stored procedure?   Is there a limitation with the with statement in a stored procedure?  I'm using Oracle 10g.

 

Errors for PROCEDURE EAN_PAGE_VIEWS:

 

 

 

LINE/COL ERROR

-------- -----------------------------------------------------------------

1/43     PLS-00103: Encountered the symbol "(" when expecting one of the

         following:

         := . ) , @ % default character

         The symbol ":=" was substituted for "(" to continue.

 

 

 

4/7      PLS-00103: Encountered the symbol "ALL_EANS" when expecting one

         of the following:

         <a SQL statement>

 

 

 

set serveroutput on;

CREATE OR REPLACE PROCEDURE ean_page_views(i_ean IN varchar2(30), i_rank IN number) IS