hetrogeneous services of Oracle

From: Arslan Dar <arslandar_at_skm.org.pk>
Date: Thu, 06 Sep 2001 06:06:24 -0700
Message-ID: <F001.00384FC2.20010906051054@fatcity.com>

hi list,

can any body kindly list the proper syntax of the DBMS_HS.CREATE_INST_INIT procedure used to set the intilization parameters of the non-oracle instance registered with oracle 8i server.

The syntax listed in documentation is

PROCEDURE create_inst_init(

FDS_INST_NAME    IN VARCHAR2
FDS_CLASS_NAME   IN VARCHAR2
INIT_VALUE_NAME  IN VARCHAR2,
INIT_VALUE       IN VARCHAR2,
INIT_VALUE_TYPE  IN VARCHAR2);

using that syntax when i try substituting my own values DBMS_HS.CREATE_INST_INIT(FDS_INST_NAME=>'hsodbc',
                     FDS_CLASS_NAME => 'ODBC65',
                     INIT_VALUE_NAME => 'HS_DESCRIBE_CACHE_HWM',
                         INIT_VALUE => '400',
                     'F');

it gives the message

DBMS_HS.CREATE_INST_INIT(FDS_INST_NAME=>'hsodbc', *

ORA-06550: line 3, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_INST_INIT'
ORA-06550: line 3, column 1:

PL/SQL: Statement ignored

WHICH point i am missing ??

Thanks in Advance,

Arslan Received on Thu Sep 06 2001 - 08:06:24 CDT