set define off.with ; or with out semicolen .
947771Apr 18 2013 — edited Apr 18 2013hi,
SET DEFINE OFF
CREATE OR REPLACE PROCEDURE myproc
IS
v_txt VARCHAR (10);
BEGIN
v_txt := '&abc';
END;
1)i want to keep this in file, please tel me should i use "SET DEFINE OFF;" OR "SET DEFINE OFF".
that is with out ";".
2) and should i put / after SET DEFINE OFF or not.
3) should i put / in last of stored proc. i keep only one stored proc in one file.
yours sincerely
Edited by: 944768 on Apr 17, 2013 10:58 PM
Edited by: 944768 on Apr 17, 2013 11:03 PM
Edited by: 944768 on Apr 17, 2013 11:11 PM