jQuery in Action, 2nd edition*
The moose likes JDBC 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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
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