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
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
Comment