Joined
Last Seen
0 Reputation Points
0% Quality Score
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
0 Endorsements
Ranked #107.41K
Hi Friends, I am having problem with the above code snippet. Initially it woked fine. But now it is giving an error of java.sql.SQLException: ORA-01722: invalid number. How can I resolve the exception? Thanks. [code=JSP] try { String ein=(String)session.getAttribute("EIN"); System.out.println("inside try block"); Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@10.9.16.2:1521:TESTDB","HE","HE123"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select distinct REV_OWNER … |