| loadjava error [message #366673] |
Tue, 05 September 2000 17:56  |
Radhesh Mohandas
Messages: 20
Registered: August 2000
|
Junior Member |
|
|
Hello,
Has any one got an idea why this error occurs when I use loadjava. However the loaded function still works.
oracle@yantra arlsw/oracle/tmp> loadjava -u scott/tiger -verbose EchoInput.java
initialization complete
loading : EchoInput
creating : EchoInput
Error while retrieving errors for EchoInput
ORA-00942: table or view does not exist
loadjava: 1 errors
~
The java function and how I published them are included here.
cat EchoInput.java echo_input.sql
public class EchoInput {
public static void main (String[[]] args) {
for (int i = 0; i < args.length; i++)
System.out.println(argsi);
}
}
CREATE OR REPLACE PROCEDURE echo_input (
s1 VARCHAR2,
s2 VARCHAR2,
s3 VARCHAR2)
AS LANGUAGE JAVA
NAME 'EchoInput.main(java.lang.String[[]])';
And I call the function using
SQL> call echo_input('1','2','3');
/
|
|
|
|
| Re: loadjava error [message #366739 is a reply to message #366673] |
Mon, 20 November 2000 12:59  |
Nicholas Gray
Messages: 13
Registered: November 2000
|
Junior Member |
|
|
Maybe this reply comes a little late, but I
encountered the same problem today.
(well almost the same .. german version complained
about invalid column name ... however it dumped
the same 'Error while retrieving errors')
Enabled tracing and noticed that what loadjava
was actually trying to do was:
select text from user_errors where name =
dbms_java.shortname('JavaFunction');
recreating JVM via:
@ %orahome%\javavm\install\initjvm.sql
fixed the problem.
try that or find out who is responsible for
creating the user_errors view
Sayonara
|
|
|
|
| Re: loadjava error [message #366742 is a reply to message #366673] |
Mon, 20 November 2000 13:43 |
Nicholas Gray
Messages: 13
Registered: November 2000
|
Junior Member |
|
|
btw. found the sql-script that creates the
user_errors view (and prepares.
So you might try this one first (much faster).
@ %orahome%\rdbms\admin\catprc.sql
Rem NAME
Rem CATPRC.SQL
Rem FUNCTION
Rem Creates data dictionary views for types,
stored procedures,
Rem and triggers.
Rem NOTES
Rem Must be run while connected to sys or internal.
Sayonara
|
|
|
|
| Re: loadjava error [message #366746 is a reply to message #366673] |
Tue, 21 November 2000 17:09 |
T. Nguyen
Messages: 5
Registered: November 2000
|
Junior Member |
|
|
Hi,
Anyone sees this error, when using loadjava
C:\>loadjava -u scott/tiger@mysys:1521:orcl -v C:\hello.java
SQl Error while connecting with thin driver to mysys:1521:orcl: Io exception: The Network Adapter could not establish the connection
could not open connection
loadjava: 2 errors
The oracle server is running, and I can connect to it.
Please let me know, thanks
T. Nguyen
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
