Hi All
I have a problem with creating the store procedure for shopping.aspx as this following
*************************
CREATE OR REPLACE PROCEDURE "SCOTT"."SHOPPINGCARTLIST" (CARTID
    IN NVARCHAR2)
is
begin
SELECT TBLPRODUCT.PRD_PRODUCTID,TBLPRODUCT.PRD_PRODUCTTIT LE,
SHOPPINGCART.QUANTITY,
TBLPRODUCT.PRD_UNITPRICE,
TBLPRODUCT.PRD_UNITPRICE*SHOPPINGCART.QUANTITY AS EXTENDEDAMOUNT
FROM
TBLPRODUCT,SHOPPINGCART
WHERE
TBLPRODUCT.PRD_PRODUCTID=SHOPPINGCART.PRODUCTID
AND
SHOPPINGCART.CARTID=CARTID
ORDER BY
TBLPRODUCT.PRD_PRODUCTTITLE;

end;

It shows this error.
******************************
LINE # = 5 COLUMN # = 1 ERROR TEXT = PLS-00428 ; AN INTO CLAUSE IS EXPECED IN THIS STATEMENT

How could i solve this problem?

Thanks in advance
Blueman137