display data with Stored procedure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Moxer
    New Member
    • Oct 2006
    • 1

    #1

    display data with Stored procedure

    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
    New Member
    • Jul 2006
    • 47

    #2
    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

    Comment

    Working...