• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-01009: missing mandatory parameter and line endings

 
Terry Mullett
Greenhorn
Posts: 26
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've spotted a couple of other ORA-01009 related messages here but none quite with quite these symptoms. Has anyone else seen this?
Using jdk1.3 and classes12_01, if I create either a Statement or a PreparedStatement from a string read in from a file, I get ORA-01009 if the file had windows line endings. If I save the file back out with Unix line endings, there's no problem. This is not a fix, however, since in many (enough) cases, CVS will checkout files with Windows line endings on a Windows box, no matter how I happened to save the file. I guess I could set up a file type for this and call it binary for CVS's sake, but it's not really a CVS problem so I'd prefer not to go that way. Has anyone else encountered this or seen a way to make the driver forgiving of line endings?
BTW, the error doesn't occur when createStatement is called, but on the first time you call next() on the result set.
Thanks
Terry
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are they read from the file using a Java application? If so, are you using Readers or InputStreams? What stops you from stripping out or converting the line endings?
- Peter
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic