Invalid attribute/identifier

[Pax73]

I have migrated my database from sql server to oracle but when I run my application in oracle 9i it gives an error - invalid attribute/identifier.

What could the problem be ? I have migrated my stored procedures as well.

Thanks in advance.

[jkoopmann]

do you have an error code associated with the error message?

sounds like there might be some procedure / logic that has a variable that is not recognized by oracle.

a place to start might be to take a look at what objects in your oracle database might have migrated but are invalid.

select object_type, owner,object_name,status from dba_objects where status = 'INVALID';

this might give you a lot of rows (hoepfully not) but you should work on re-compiling thos objects that are invalid or determine they are not needed for your application.

you can recompile the invalid objects by :
alter <object_type> <object_name> compile;

once you find the objects that will not compile you can extract the source from the dba_source view:

select text from dba_source where owner = <owner> and name = <object_name> order by line;

then verify the code and try and re-create the object.

when you try and recreate the object through say SQL*Plus Oracle will point you to the line that the error or unrecognized variable is on. you can then use the list line command 'l #' where # is the line number and take a look at the variable.

hope this works for you

[Pax73]

Thanks for the help. Yes, I compiled the procedures and some(!) to be invalid.