| Re: [ Problem in configuring SQL Listner for external procedure ] [message #75874] |
Wed, 17 October 2001 23:55 |
Heidi
Messages: 37
Registered: February 2000
|
Member |
|
|
The case should be the same in the listener as in tnsnames.ora.
Another nice-to-know : when you're working in shared mode (Multithreaded server install) you cannot use external procedures ! Make a new alias to connect using a dedicated process in tnsnames :
PORTORA_ded =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = provlimport)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = portora)(SERVER=DEDICATED)
)
)
notice the line (SERVER=DEDICATED)
When you connect with this alias you can use ext proc's ....
hope this helps...
Heidi
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
