Oracle 8.1.5 - DBMS_REPCAT package

I was attempting to invoke this package procedure but I am having
problem
determine correct data type for parameters.

I am interfacing to Oracle 8.1.5 via Delphi CS 3.02/BDE/ODBC and
everytime I
attempt to retrieve the parameters for this
procedure, I get the following error as viewed through SQL Monitor:

88      09:32:24  SQL Vendor: ODBC - SQLError
89      09:32:24  SQL Error: OracleServer - [Oracle][ODBC][Ora]ORA-
24345: A
Truncation or null fetch error occurred
90      09:32:24  SQL Vendor: ODBC - SQLError
91      09:32:24  SQL Error: OracleServer - [Oracle][ODBC]SQL data type
out
of range <6>.
92      09:32:24  SQL Vendor: ODBC - SQLError
93      09:32:24  SQL Error: OracleServer - Unmapped SQL Error Code: 0
94      09:32:24  SQL Stmt: OracleServer - ERROR
95      09:32:24  SQL Stmt: OracleServer - Close
96      09:32:24  SQL Vendor: ODBC - SQLFreeStmt

Looking at the prototype of the procedure, I think I see what is
causing the
problem:

PROCEDURE drop_master_repgroup(gname                IN VARCHAR2,

drop_contents
IN BOOLEAN := FALSE,
                                                            all_sites
IN BOOLEAN := FALSE);

My guess is that BOOLEAN is specific type for Oracle and does not
translate
to BDE data type.

But if I run ODBC Ansi Test Tool (part of MDAC), even the ODBC driver
seems
to have a problem translating the data type
correctly:

SQLProcedureColumns:
    In:    StatementHandle = 0x00BF0740, CatalogName = SQL_NULL_HANDLE,
          NameLength1 = 0, SchemaName = "SYS", NameLength2 = 3,
          ProcName = "DBMS_REPCAT.DROP_MASTER_REPGROUP", NameLength3 =
32,
ColumnName = SQL_NULL_HANDLE, NameLength4 = 0
    Return: SQL_SUCCESS=0

Get Data All:
"PROCEDURE_CAT", "PROCEDURE_SCHEM", "PROCEDURE_NAME", "COLUMN_NAME",
"COLUMN_TYPE", "DATA_TYPE", "TYPE_NAME", "COLUMN_SIZE", "BUFFER_LENGTH",
"DECIMAL_DIGITS", "NUM_PREC_RADIX", "NULLABLE", "REMARKS", "COLUMN_DEF",
"SQL_DATA_TYPE", "SQL_DATETIME_SUB", "CHAR_OCTET_LENGTH",
"ORDINAL_POSITION", "IS_NULLABLE"
<Null>, "SYS", "DBMS_REPCAT.DROP_MASTER_REPGRO", "GNAME", 1,
12, "VARCHAR2",
2000, 2000, <Null>, <Null>, 2, <Null>, <Null>, 12, , 2000, 1, ""
<Null>, "SYS", "DBMS_REPCAT.DROP_MASTER_REPGRO", "DROP_CONTENTS", 1,
ERROR,
"PL/SQL BOOLEAN", ERROR, ERROR, <Null>, <Null>, 2, <Null>, <Null>,
ERROR,
ERROR, ERROR, 2, ""
<Null>, "SYS", "DBMS_REPCAT.DROP_MASTER_REPGRO", "ALL_SITES", 1, ERROR,
"PL/SQL BOOLEAN", ERROR, ERROR, <Null>, <Null>, 2, <Null>, <Null>,
ERROR,
ERROR, ERROR, 3, ""
3 rows fetched from 19 columns.

My question from all of this, am I dead in the water in attempting to
invoke
this package procedure? Or do I need to go
through another database interface (OCI) to properly invoke this package
procedure.

TIA,
Dave.

Sent via Deja.com http://www.deja.com/
Before you buy.