This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Oracle Stored Procedure
 
Similar Threads
writing log to a file from java stored procedure
Call a stored Proc from JavaSript? Is it possible?
Passing an integer array to a Oracle Stored Procedure
calling stored procedure in oracle which returns a table
Passing array to CallableStatement