OraFAQ Forum: Warehouse Builder » 'IN' is not a valid integer value

Home » Developer & Programmer » Warehouse Builder » 'IN' is not a valid integer value

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

'IN' is not a valid integer value [message #250078]

Sat, 07 July 2007 11:20

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;

Report message to a moderator

Re: 'IN' is not a valid integer value [message #250226 is a reply to message #250078]

Mon, 09 July 2007 03:29

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,

Report message to a moderator

Re: 'IN' is not a valid integer value [message #250283 is a reply to message #250226]

Mon, 09 July 2007 08:13

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.

Report message to a moderator

Re: 'IN' is not a valid integer value [message #251253 is a reply to message #250283]

Thu, 12 July 2007 14:15

Littlefoot
Messages: 16997
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.

Report message to a moderator

Re: 'IN' is not a valid integer value [message #251828 is a reply to message #251253]

Mon, 16 July 2007 17:00

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.

Report message to a moderator

Previous Topic:	Excel to OWB odbc connection
Next Topic:	Converting from Oracle Express Objects to Standard Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 04:48:21 CDT 2013

Total time taken to generate the page: 0.12765 seconds