| Installing DBMS_JAVA package. [message #51334] |
Thu, 16 May 2002 03:58  |
Milind S Deobhankar
Messages: 33
Registered: January 2002
|
Member |
|
|
Hi,
I had created the Oracle Server Manuaaly at that time JServer was not installed so i install it from the PLSQL
/javavm/install/initjvm.sql
J server was sucessfully installed and even i can see the JSERVER started prompt when i connect to the database.
Actually I want to enable mailing from oracle so i try out
/rdbms/admin/initplsj.sql
But when I jun this it says that dbms_java Package not available can anybody tell me where i can get that package.
Thanks in advance.
|
|
|
|
| Re: Installing DBMS_JAVA package. [message #51335 is a reply to message #51334] |
Thu, 16 May 2002 04:38  |
ksr
Messages: 112
Registered: January 2002
|
Senior Member |
|
|
check the things, whether the dbms_java is available or not
select count(*) from DBA_OBJECTS where OBJECT_TYPE like 'JAVA%'; -- what count does this give you
select count(*) from DBA_OBJECTS where OBJECT_TYPE like 'JAVA%' and STATUS = 'INVALID';
If everything was installed properly then you should not see any invalid objects
|
|
|
|
| Re: Installing DBMS_JAVA package. [message #51337 is a reply to message #51334] |
Thu, 16 May 2002 04:40 |
ksr
Messages: 112
Registered: January 2002
|
Senior Member |
|
|
check the things, whether the dbms_java is available or not
select count(*) from DBA_OBJECTS where OBJECT_TYPE like 'JAVA%'; -- what count does this give you
select count(*) from DBA_OBJECTS where OBJECT_TYPE like 'JAVA%' and STATUS = 'INVALID';
If everything was installed properly then you should not see any invalid objects
|
|
|
|
| Regarding your Quries KIM [message #51348 is a reply to message #51334] |
Thu, 16 May 2002 21:13 |
Milind S Deobhankar
Messages: 33
Registered: January 2002
|
Member |
|
|
Hi,
I had tried out your both option the result is as follow:
SQL> select count(*) from DBA_OBJECTS where OBJECT_TYPE like 'JAVA%';
COUNT(*)
----------
0
SQL> select count(*) from DBA_OBJECTS where OBJECT_TYPE like 'JAVA%' and
STATUS = 'INVALID';
COUNT(*)
----------
0
Can you help furthur for that. I am not able to even do the following:
SQL> desc dbms_java
ERROR:
ORA-04043: object dbms_java does not exist
That means the package is not available in DB.
Please help me for the same.
If you furthur want any clarification than let me know
Regards,
Milind
http://milinddev.tripod.com
|
|
|
|
|
|
| Re: Regarding your Quries KIM [message #52496 is a reply to message #51334] |
Fri, 26 July 2002 03:02 |
valliappan
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
I would like to know in Oracle
1.Can we change the column name of the Table
2.What is maxium no of column that can be created
3.What is the max length of quries in Oracle
4.Give a simple defintion of class and object with
example(I would like the example to be in small program)
5.Can i declare a variable with underscore.
6.Why is that we should use underscore in your mailid if we want.Why cant that be in - or /.
Thankyou
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
