PLS-00390 (1):PLS-00390: undefined column '%s' in INSERT statement

[lee]

Hi,
I have a Procedure which is invlaid and the error is:
'PLS-00390: undefined column 'GETS_PER_EXEC' in INSERT statement'. Does anybody know what this error is?

The column is existing in the table.

Please help. It's urgent!!

Thanks.

[stecal]

Please cut and paste the results of describe tablename here along with the insert statement.

[lee]

Hey!! I figured out the problem. The columns in the table were in lowercase. ( I wonder how??) . So I droppd and re-created the table. There is no error now.


Thanks.

[Shestakov]

Did u use some migration tool for create this table.
It may be problem.
I saw problem like this , probably, with MS Access to Oracle Migration assistant.

[lee]

When? Before or after the problem?

[Shestakov]

Before