How to publish java stored procedure Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to publish java stored procedure

  1. #1
    Join Date
    Aug 2000
    I encountered problem when publishing java stored proedure in oracle 8.1.6.
    Here is the java program:
    public class swapper {
    public static void swap( int[] x,int[] y) {
    int hold = x[0];
    x[0] = y[0];
    y[0] = hold;

    Then I use loadjava utility:
    C:>loadjava -user system/manager@orcl -v
    I checked the user_objects table about,the status is valid.
    Then i goto sqlplus system/manager to publish the java stored
    procedure as following:
    sql>create or replace procedure swap(x in out number,y in out number)
    as language java
    name 'swapper.swap(int[],int[])';
    system give error msg:
    warning:procedure created with compilation error
    after that
    I check the user_objects table about swap procedure,I found the status is invalid. When I try to call this java stored procedure in PL/SQL. The error msg is invalid procdure;
    pls help me

  2. #2
    Join Date
    Aug 2000

  3. #3
    Join Date
    Oct 2000
    What's the problem anyway?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width