Home » Server Options » Text & interMedia » Re: [ Problem in configuring SQL Listner for external procedure ]
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

----------------------------------------------------------------------
Previous Topic: Re: [ Problem in configuring SQL Listner for external procedure ]
Next Topic: How to get any documents that contain special terms such as about, sync, AND, OR, ...
Goto Forum:
  


Current Time: Thu Mar 28 08:53:17 CDT 2024