Skip to Content
0
Former Member
Dec 03, 2008 at 02:13 PM

Error in File to Jdbc.

62 Views

Hi all

I am trying to do a simple File to Jdbc scenario.table has 2 fields empno and empname.i am able to insert records into the database successfull without any data in empname ,but when trying to insert a record with value in empname it is giving me the error " Error when executing statement for table/stored proc. 'EMPLOYEE' (structure 'STATEMENT'): java.sql.SQLException: ORA-00984: column not allowed here ".

empname in database is of type varchar and length 100

and in IR it is of type string.

plz help me in resolving the issue

<It is against the rules of Engagement to post a question with the catch of awarding points. Please refrain from the same.>

Regards

Bhasker

Edited by: Bhavesh Kantilal on Dec 3, 2008 10:26 AM