display data with Stored procedure

[Moxer]

Freinds,

I am new comer to oracle platform, now I would like to try to create stored procedure with this db, while my SP only display data with some parameter, I've been create SP but I'get some error while compile.

CREATE or REPLACE PROCEDURE OGS_EXP.custmr (custmr out char(6)) AS
SELECT ID_CUSTMR FROM ogs_exp.t_bkng_m where id_custmr :custmr;
end;

may I know whats wrong with this syntax? thx for your adv

Warm Regards,
Moxer

[saravanankm]

Hi


pls Check Ur where cluse Condition

CREATE or REPLACE PROCEDURE OGS_EXP.custmr (custmr out char(6)) AS
SELECT ID_CUSTMR FROM ogs_exp.t_bkng_m where id_custmr = custmr;
end;

With Regards,
Captain