This discussion is archived
3 Replies Latest reply: Nov 3, 2012 9:04 AM by jschellSomeoneStoleMyAlias RSS

Java Stored Procedures and Triggers

971536 Newbie
Currently Being Moderated
I want to to use Java stored procedures and triggers within the Oracle 11g XE
So please , someone can help me because i tried but it didn't work
I don't know where is the problem
Thanks !!
  • 1. Re: Java Stored Procedures and Triggers
    rp0428 Guru
    Currently Being Moderated
    WRONG FORUM!

    Welcome to the forum but this forum is for Java JDBC questions and issues. Your question should be posted in the SQL and PL/SQL forum
    SQL and PL/SQL
    >
    I want to to use Java stored procedures and triggers within the Oracle 11g XE
    So please , someone can help me because i tried but it didn't work
    I don't know where is the problem
    >
    Mark this question ANSWERED and repost the question in the other forum

    Before you post review the Oracle Database Java Developer's Guide - it shows how to create Java stored procedures and has example code
    http://docs.oracle.com/cd/B28359_01/java.111/b31225/chfive.htm

    And in the new post don't just say "I tried but it didn't work". You need to post the code that you tried and what you mean by "didn't work".
    If you got any exceptions or errors you need to post a copy of the exact message or error that you are getting.
  • 2. Re: Java Stored Procedures and Triggers
    971536 Newbie
    Currently Being Moderated
    thank you
    but in this web site http://docs.oracle.com/cd/B28359_01/java.111/b31225/chfive.htm
    when they tolk about" Java Stored Procedures Steps" I didin't understand step 2:Load and Resolve the Java Classes
    where we do this step.??
  • 3. Re: Java Stored Procedures and Triggers
    jschellSomeoneStoleMyAlias Expert
    Currently Being Moderated
    968533 wrote:
    thank you
    but in this web site http://docs.oracle.com/cd/B28359_01/java.111/b31225/chfive.htm
    when they tolk about" Java Stored Procedures Steps" I didin't understand step 2:Load and Resolve the Java Classes
    where we do this step.??
    It says...

    +"Using the loadjava tool, you can load Java source, class, and resource files into Oracle Database instance, where they are stored as Java schema objects. You can run the loadjava tool from the command line"+

    A command line is also a console window. If it fails in the command window with and error like 'command not found' then you must locate the executable in the oracle install and either run it from that directory or add the directory to your platform path (that has nothing to do with java.)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points