• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Missing IN or OUT parameter at index:: 1

 
Allen Bandela
Ranch Hand
Posts: 128
Eclipse IDE MS IE Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm getting the above SQLException while executing a PreparedStatement. I didn't get an error while testing though.



Its pretty simple. But, wonder why the exception. Driver used Oracle Jdbc driver. Has anyone faced a similar situation and what was your approach to solve it. Thanks.
 
Jan Cumps
Bartender
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
At first sight, your example code looks ok.
Maybe if you post the real code, and the complete error output, we can tell more.

Regards, Jan
 
Allen Bandela
Ranch Hand
Posts: 128
Eclipse IDE MS IE Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for trying to help.Here's the code. And the exception error message is in the subject line. Its a java.sql.SQLException.
ColumnA is a Number and ColumnB is a VARCHAR2.



(Do you think that if this.columnBValue is null, it would give this exception?)

[ July 03, 2007: Message edited by: Sylvester James ]

[ July 03, 2007: Message edited by: Sylvester James ]
[ July 03, 2007: Message edited by: Sylvester James ]
 
Jan Cumps
Bartender
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
(Do you think that if this.columnBValue is null, it would give this exception?)
That's something you can test. Try how the code behaves when the attribute has a value, and when it's null.
 
Herman Schelti
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi Sylvester,

why do you have a static Preparedstatement and Connection?

Herman
PS your code does not compile, please only sent exact code (just copy/paste)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic