-
Hi,
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 swapper.java
I checked the user_objects table about swapper.java,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
-
-
What's the problem anyway?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|