, ,

R12 – java.sql.SQLException: Invalid column type in OAF

Issue:
When we are using view object (VO) in OA Framework it’s possible that you will run in to the problem java.sql.SQLException: Invalid column type, especially if it’s an LOV VO. When you click on the LOV torch for the first time it is working fine. But whenever when we click on the GO button in the LOV Region it gives an error.

Solution:
What we need to is, change the Binding Style from Oracle Named to Oracle Positional in the View Object declaration. The framework is adding a where clause to the query using bind variables that are typed :n, this is why you need to set Oracle Positional. Now save it run again, then it will solve this issue.

VO Binding Style

4 replies
  1. Akshay
    Akshay says:

    It is not working in apps dev instance. it is working fine in jdeveloper. can you suggest on voimpl.class file or xml

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply