File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Stored Procedure" Watch "Oracle Stored Procedure" New topic

Oracle Stored Procedure

Raja Raja

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 and 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.

I agree. Here's the link:
subject: Oracle Stored Procedure
Similar Threads
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
writing log to a file from java stored procedure
Passing array to CallableStatement