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 Relational Databases and the fly likes Compilation problem Java function in Oracle 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 "Compilation problem Java function in Oracle" Watch "Compilation problem Java function in Oracle" New topic
Author

Compilation problem Java function in Oracle

manvendra singh
Greenhorn

Joined: Feb 05, 2011
Posts: 3

M trying to call my java class function as pl sql function..

I dont have databse at my local machine....using sqldeveloper for database access.

So to load my java class I am using Load Java option mentioned in Java section in sqldeveloper.
My Class have a stand alone logic and have no dependencies...
I am using this java in Oracle option first time ....
Please suugest if I am making any silly mistake.

I am getting following exception when pressing apply after giving the source in source_tab and and same name as class name in Name_tab.


the class I am trying to compile is........





when I try to view my object status in DB, all my attempts are at invalid status

SELECT OBJECT_NAME, OBJECT_TYPE, STATUS
FROM USER_OBJECTS
WHERE OBJECT_TYPE IN ('JAVA SOURCE', 'JAVA CLASS', 'JAVA RESOURCE')
ORDER BY OBJECT_TYPE, OBJECT_NAME;

MorpherLast JAVA CLASS INVALID
TextMorpher JAVA CLASS INVALID
TextMorpher1 JAVA CLASS INVALID
MorpherLast JAVA SOURCE INVALID
TextMorpher JAVA SOURCE INVALID
TextMorpher1 JAVA SOURCE INVALID

I am even not able to drop these wrong compile Object from DB..............
.................
Please help.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Compilation problem Java function in Oracle