File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
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
jQuery in Action, 3rd edition