Home » Developer & Programmer » Data Integration » 'IN' is not a valid integer value
'IN' is not a valid integer value [message #250078] Sat, 07 July 2007 11:20 Go to next message
mdkora
Messages: 8
Registered: July 2007
Location: US
Junior Member
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;
Re: 'IN' is not a valid integer value [message #250226 is a reply to message #250078] Mon, 09 July 2007 03:29 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

You used INTEGER as data type but oracle does not support INTERGER data type it supports NUMBER data type instead of INTEGER.
Try it by changing data type from INTEGER to NUMBER.

Regards
Sanka,
Re: 'IN' is not a valid integer value [message #250283 is a reply to message #250226] Mon, 09 July 2007 08:13 Go to previous messageGo to next message
mdkora
Messages: 8
Registered: July 2007
Location: US
Junior Member
Thanks, I have replaced integer with number. Now i have created a procedure in sql*plus. But i cannot execute the same procedure in TOAD. I get the same error.
Re: 'IN' is not a valid integer value [message #251253 is a reply to message #250283] Thu, 12 July 2007 14:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, INTEGER / NUMBER distinction has nothing to do with your problem. You can easily leave it as INTEGER if you wish; the problem is in an invalid INSERT INTO syntax; it wouldn't work in SQL (so there's no reason for it to work in PL/SQL either). BTW, I guess the procedure was created with compilation errors.

The correct syntax is
INSERT INTO TABLE1 VALUES (i,'Name');

You missed the VALUES keyword.
Re: 'IN' is not a valid integer value [message #251828 is a reply to message #251253] Mon, 16 July 2007 17:00 Go to previous message
mdkora
Messages: 8
Registered: July 2007
Location: US
Junior Member
I have fixed this problem with the patch from the below link.

http://www.nabble.com/RE:-10-G-database---IN-is-not-a-valid-integer-value-p3405244.html

Thanks for the response.
Previous Topic: Excel to OWB odbc connection
Next Topic: Converting from Oracle Express Objects to Standard Form
Goto Forum:
  


Current Time: Fri Mar 29 04:14:49 CDT 2024