aspose file tools*
The moose likes JDBC and the fly likes Oracle Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Stored Procedure" Watch "Oracle Stored Procedure" New topic
Author

Oracle Stored Procedure

Raja Raja
Greenhorn

Joined: May 17, 2003
Posts: 8
App Server : Weblogic 6.1 on Unix
DataBase : Oracle 9i on Unix

when i call a oracle stored procedure from session bean i get a n array of results from the procedure. But the array has calues in heya decimal.
can anyone say does this occur. ? I have set nlscharset.zip and classes12.zip in classpath
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
This doesn't make any sense to me. Surely if a numeric value is returned from the database it will just be a number. Whether that number is represented as hexadecimal or decimal or whatever is merely a matter of formatting for display purposes. Or are you getting these hexadecimal values back as character-based data types?

Perhaps it would clarify things if you posted a sample of your code.

Jules
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle Stored Procedure