DBMS_TCP and DBMS_SMTP packages [message #35626] |
Tue, 02 October 2001 07:07 |
Inayat
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
Could anyone please tell me if I need to run any catalogue script to set up the packages DBMS_TCP and DBMS_SMTP ?
I have Oracle 8i installed, but when querying the DBA_OBJECTS, I don't see the above two packages listed!
Please help me as this requirement is urgent. Thanks,
Inayat
----------------------------------------------------------------------
|
|
|
|
ask dba to install Jserver option in oracle8i [message #35666 is a reply to message #35626] |
Thu, 04 October 2001 13:13 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
I had the same problem before and it has been solved. The reason is that the utl_xxx packages rely on the JServer option of oracle8i, ask ur DBAs to install this option, then all the required java class will load into database.
Good luck,
----------------------------------------------------------------------
|
|
|
Re: ask dba to install Jserver option in oracle8i [message #35668 is a reply to message #35666] |
Thu, 04 October 2001 15:26 |
Inayat
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
Dear Frank:
The JServer option is already installed and yet I get the same error.
ORA-29540: class oracle/plsql/net/TCPConnection does not exist
I queried for the presence of the utl_smtp and utl_tcp packages from the SQL prompt and they are there! I could also 'describe' them meaning I have execute privileges on it as a user, and not privileges through a role. Please suggest me if I still need to reinstall Oracle with the JServer option or do you have any other idea?
Thanks and regards
Inayat
----------------------------------------------------------------------
|
|
|
Try this [message #35670 is a reply to message #35668] |
Thu, 04 October 2001 16:19 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Run ORACLE_HOME/rdbms/admin/initplsj.sql as SYS
or
loadjava -user sys/*** $ORACLE_HOME/plsql/jlib/plsql.jar
If u use oracle universal installer's default option, it will install the JServer for u while u install oracle8i.
For further information, u may check OTN online document about how to install JServer.
good luck
----------------------------------------------------------------------
|
|
|