• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Compilation problem Java function in Oracle

 
Greenhorn
Posts: 3
Hibernate Eclipse IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic