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
