File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Java Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Java Stored Procedure" Watch "Java Stored Procedure" New topic

Java Stored Procedure

Ryan Bailey
Ranch Hand

Joined: Feb 26, 2002
Posts: 134
I am executing a stored procedure with no luck. Here's the senario...

This method is being called with an encrypted String. When I call the stored procedure to decrypt the value an exception is being thrown. Below is the exception.

I believe this error is occuring because my value has a single hyphen in the String and Oracle things this is the end of the String. I tried to override the hyphen by placing another hyphen where ever it occurs in the String but that didn't help either.
Any help on this topic would be greatly appreciated.
Thanks in advance for your time,

Java: The power, elegance, and simplicity of a hand grenade
makiey bartsch

Joined: Feb 27, 2002
Posts: 11
Make sure that the length of the data to be encrypted or decrypted is a multiple of 8 bytes.
I agree. Here's the link:
subject: Java Stored Procedure
It's not a secret anymore!