File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java Stored Procedure" Watch "Java Stored Procedure" New topic
Author

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,
Ryan


SCJP 1.4, SCWCD
Java: The power, elegance, and simplicity of a hand grenade
makiey bartsch
Greenhorn

Joined: Feb 27, 2002
Posts: 11
hi,
Make sure that the length of the data to be encrypted or decrypted is a multiple of 8 bytes.
greetings,
makiey
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Stored Procedure
 
Similar Threads
ORA-01002: fetch out of sequence when trying to insert CLOB data into Oracle
Determine the Callable Statements Parameters at runtime
Reg: Writing Oracle JavaStored Procedures
JDBC connection using eclipse ide
how do i get this boolean