I am using TOAD 8.5 and oracle 10.2. When i compile a procedure i get this error 'IN' is not a valid integer value.
I have a simple procedure
CREATE TABLE TABLE1(NO NUMBER, NAME VARCHAR2(10));
CREATE OR REPLACE PROCEDURE PROC(i IN INTEGER) AS
BEGIN
INSERT INTO TABLE1(i,'Name');
END PROC;