dynamic input value passing [message #638684] |
Thu, 18 June 2015 04:40 |
|
arun888
Messages: 100 Registered: June 2015 Location: INDIA
|
Senior Member |
|
|
hi I have created a procedure and passing the store value staticly in the below procedure.
if the user need to pass the store value as input. how to re-write the code.
any idea please.
create or replace procedure test10 is
c_str store.store%type;
c_subchain store.subchain%type;
c_chain store.chain%type;
BEGIN
c_str :=47377;
select chain, subchain INTO c_chain, c_subchain from store where store = c_str;
DBMS_OUTPUT.PUT_LINE(c_chain);
END;
|
|
|
|
|
|