| From: BROKE::BITHER "Please reply to dbither@us.oracle.com" 1-APR-1997 11:59:52.12
To: M5::MGULLIKS
CC: BITHER
Subj: New STARS Article - thanks, Diane
TITLE: RDMS-E-NORTNENTRY, Can Not Find Entry Point for the Routine
PRODUCT: Oracle Rdb
OP/SYS: OpenVMS VAX, OpenVMS AXP
SOURCE: Oracle Worldwide Customer Support
PROBLEM:
An external function call that activates an external routine results in the
following error:
SQL> select odbctest() from rdb$database;
%RDB-E-EXTFUN_FAIL, external routine failed to compile or execute successfully
-RDMS-E-INVRTNUSE, routine ODBCTEST can not be used in this request - image
sys$common:[sqluser61.coda]odbctest.exe not activated
-RDMS-E-NORTNENTRY, can not find entry point for the routine ODBCTEST
PROBLEM CAUSE:
The shareable image ODBCTEST.EXE has been linked without specifying the
external routine name as a universal symbol on a VAX or as a symbol
vector on an AXP.
SOLUTION:
On a VAX:
$ link/share odbctest, sys$input/opt
universal = odbctest ! where odbctest is the routinename
(Ctrl-Z)
OR
Create options file odbctest.opt which contains the line:
universal = odbctest
$ link/share odbctest, odbctest.opt/opt
On an AXP:
$ link/share odbctestaxp, sys$input/opt
symbol_vector = (odbctest = procedure) ! where odbctest is the routinename
(Ctrl-Z)
OR
Create options file odbctest.opt which contains the line:
symbol_vector = (odbctest = procedure)
$ link/share odbctest, odbctest.opt/opt
See the Oracle Rdb7 Guide to SQL Programming, Chapter 14 "Using External
Routines," section 14.6 "Creating Shareable Images for External Routines"
for more information.
\
\ CONTRIBUTORS:
\
\ Technical: Diane Bither
|