Stored Procedures

[bduke]

I'm in the process of creating a stored procedure, but everytime it compiles I receive this error
ORA 06550 Line 1 column 7;
PLS- 00905 : object XXX.parcel_t6 is invalid
(parcel_t6 is the stored procedure that I'm trying to create)
Here is a sample of what I'm trying to do. I have modified to see if I could get past the error in Line 1.

CREATE OR REPLACE PROCEDURE parcel_t6 (
d_name in Char) is
select * from XXX.ADP_PAR
END parcel_t6;
/

Thanks for any information that you could provide.

[jmodic]

Appart for whole lot of syntax errors in your procedure, you must select INTO something in the PL/SQL. Your procedure should look something like:

CREATE OR REPLACE PROCEDURE parcel_t6 ( d_name  in Char) is
  adp_par_row  XXX.ADP_PAR%ROWTYPE;
BEGIN
  select * INTO adp_par_row from XXX.ADP_PAR;
  ......
EXCEPTION
  WHEN ......
END parcel_t6;
/