Go Back   Wiki NewForum > Career Forum (Documents/Tutorials/Advice) > Tech Forum & Tutorial > Oracle Database, SQL, Application, Programming

Sponsored Links

Views: 783 Source: CNN18.com, India-Forums, TellyChakkar, India, Times of India, Youtube, BollywoodLife, Rediff  
Thread Tools Rate Thread Display Modes
Old 05-26-2009, 01:33 PM
bholus7 bholus7 is offline
Join Date:
Apr 2009
Posts: 1,322
Default Set up for calling external procedures from Pl/SQL

Set up for calling external procedures from Pl/SQL

Oracle8 has provided a coll new feature called "External procedures". Which in simple terms gives you ability to call any program on Operating system from within a stored program unit. Prior to this, only way to do this was to use deamons & pipes or Pro*C. Fot this to work DBA needs to do following setup.
Create a separate listener for external procedures. Add following entries to your listener.ora
(ADDRESS= (PROTOCOL= TCP)(Host= machine)(Port= 1526))
(SID_NAME = external)
(ORACLE_HOME = /oracle/app/oracle/product/8.0.5)
(PROGRAM = /oracle/app/oracle/product/8.0.5/bin/extproc)
Thing to take care is that SID should not clash with a valid database SID
Then add an alias in tnsnames.ora for this connection
extproc_connection_data.world =
(ADDRESS = (PROTOCOL = TCP)(Host=machine)(Port=1526))
(CONNECT_DATA = (SID = external))

Reply With Quote

New topics in Oracle Database, SQL, Application, Programming

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.