This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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
jQuery in Action, 3rd edition