Topic: SQL*Plus and PL/SQL >> class SAMPLE.Pgm1 could not be resolved
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: class SAMPLE.Pgm1 could not be resolved |
| karthi |
Posted: Jul 19, 2007 07:25:18 AM |
Total Post: 2
Joined: Jul, 2007
|
Hi,
i tried to load java program in to the oracle. but i am getting error. after loaded the java program that status is invalid.
Code: Select all
D:\logfilemonitor1>loadjava -verbose -user SAMPLE/SAMPLE@orcl Pgm1.class
arguments: '-verbose' '-user' 'SAMPLE/SAMPLE@orcl' 'Pgm1.class'
creating : class Pgm1
loading : class Pgm1
SQL> select DBMS_JAVA.LONGNAME(OBJECT_NAME) as OBJECT_NAME ,STATUS from ALL_OB
JECTS where OBJECT_TYPE like 'JAVA%' and OWNER='SAMPLE';
OBJECT_NAME STATUS
------- -------------
PGM1 INVALID
then i connected to SAMPLE/SAMPLE . then i excuted following PL/SQL script.
Code: Select all
SQL> CREATE FUNCTION hello_there1 (to_whom IN VARCHAR2)
2 RETURN VARCHAR2
3 AS LANGUAGE JAVA
4 NAME 'Pgm1.sayIt
5 (java.lang.String) return java.lang.String';
6 /
Function created.
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE(hello_there1('world'));
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-29541: class SAMPLE.Pgm1 could not be resolved
ORA-06512: at "SAMPLE.HELLO_THERE1", line 0
ORA-06512: at line 2
I am getting following error. this is first time i am using loadjava. any body help me.
Thanks,
kkkarthi
Member
Posts: 2
Joined: Thu Jul 19, 2007 10:01 am |
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Vinoth Kumar | 357 |
| Gopu Gopi | 340 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
