3 Replies Latest reply: Nov 3, 2012 11:04 AM by jschellSomeoneStoleMyAlias RSS

    Java Stored Procedures and Triggers

    971536

      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
          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
            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
              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.)