1. version number = 9.2.0.7.0
2. there is no error message. the code compiles fine and when i try to
execute i get "pl/sql procedure executed successfully"
3. BKDP_MISSINGFIELDS
(
ACCOUNT VARCHAR2(20 BYTE) NOT NULL,
PRO_SE INTEGER,
LEGAL_NAME VARCHAR2(35 BYTE),
PACER_NUMBER VARCHAR2(20 BYTE),
PACER_AMOUNT NUMBER,
PACER_USE INTEGER,
TRUSTEE_NUMBER VARCHAR2(20 BYTE),
TRUSTEE_AMOUNT NUMBER,
SITE_ID VARCHAR2(1 BYTE),
SECURITY_TYPE_ID CHAR(5 BYTE),
SECURITY_FLAG INTEGER,
POP INTEGER,
PERC_UNSECURED NUMBER,
CONFIRMATION_DATE DATE,
CONVERSION_DATE DATE,
POC_ACK_DATE DATE
)

RACCOUNT
(
DIVISION_ID VARCHAR2(6 BYTE) NOT NULL,
ACCOUNT VARCHAR2(20 BYTE) NOT NULL,
PRIM_DIVISION_ID VARCHAR2(6 BYTE) NOT NULL,
PRIM_ACCOUNT VARCHAR2(20 BYTE),
LINK_STAT NUMBER(2),
RM_START_DATE DATE,
PRODUCT_CODE VARCHAR2(6 BYTE),
NO_ACCOUNTS NUMBER(2),
BRANCH_NUMBER VARCHAR2(6 BYTE),
CREDIT_LIMIT NUMBER(14,4),
DTE_LST_CR_CHG DATE,
CONTRACT_DATE DATE,
INT_RATE_CODE VARCHAR2(4 BYTE),
INT_START_DATE DATE,
CYCLE_CODE NUMBER(2),
LAST_POST_DATE DATE,
ACCUM_DATE DATE,
CHGOFF_DATE DATE,
CHGOFF_RSN_CODE VARCHAR2(3 BYTE),
CHGOFF_PRINCPAL NUMBER(14,4),
CHGOFF_INTEREST NUMBER(14,4),
CHGOFF_OTH_AMTS NUMBER(14,4),
REASON_INTO_COL VARCHAR2(3 BYTE),
CYCLES_DELQ NUMBER(3),
LAST_PAY_DATE DATE,
LAST_CONT_DATE DATE,
LAST_NOTE_DATE DATE,
LAST_NOTE_CODE VARCHAR2(3 BYTE),
RESPONSIBILITY VARCHAR2(6 BYTE),
RESP_TYPE CHAR(1 BYTE),
STATUS VARCHAR2(4 BYTE),
NEXT_STAT_DATE DATE,
ALLOC_CODE VARCHAR2(6 BYTE),
TOT_CHARGES NUMBER(14,4),
TOT_PRINCIPAL NUMBER(14,4),
TOT_INTEREST NUMBER(14,4),
TOT_COST NUMBER(14,4),
TOT_OTHER NUMBER(14,4),
TOT_NUM_PMTS NUMBER(8),
TOT_PTD NUMBER(14,4),
TOT_PRIN_PTD NUMBER(14,4),
TOT_INT_PTD NUMBER(14,4),
TOT_COST_PTD NUMBER(14,4),
TOT_OTH_INC_PTD NUMBER(14,4),
TOT_DELQ_AMT NUMBER(14,4),
TOT_DUE_AMT NUMBER(14,4),
TOT_PRIN_DUE NUMBER(14,4),
TOT_INT_DUE NUMBER(14,4),
TOT_COSTS_DUE NUMBER(14,4),
TOT_OTHER_DUE NUMBER(14,4),
OVER_LIMIT_AMT NUMBER(14,4),
PCT_BAL_OVR_LMT NUMBER(14,4),
SETTLE_ALLOW NUMBER(14,4),
DISPU_PCT_BAL NUMBER(6,2),
DEBTS_SINCE_ENT NUMBER(4),
TOT_NSF_AMT NUMBER(14,4),
NUM_NSF_PMNTS NUMBER(4),
DATE_LAST_NSF DATE,
LAST_STMT_DATE DATE,
FRST_PMT_DATE DATE,
FIRST_PMT_AMOUNT NUMBER(14,4),
NEXT_CYCLE VARCHAR2(6 BYTE),
NXT_SCH_PMT_DTE DATE,
NXT_SCH_PMT_AMT NUMBER(14,4),
NXT_SCH_PRN_PMT NUMBER(14,4),
NXT_SCH_INT_PMT NUMBER(14,4),
NXT_SCH_CST_PMT NUMBER(14,4),
NXT_SCH_OTH_PMT NUMBER(14,4),
CALL_ATMPS_CONT NUMBER(6),
WKDY_CALL_ATMPS NUMBER(6),
WKNT_CALL_ATMPS NUMBER(6),
WKND_CALL_ATMPS NUMBER(6),
BKN_PROM_S_ENT NUMBER(6),
PLACEMENT_CODE NUMBER(2),
DATE_SENT_AGENCY DATE,
DATE_LAST_RECALL DATE,
BAD_ADDR_FLAG CHAR(1 BYTE),
HOME_OWN_FLAG CHAR(1 BYTE),
HOLD_FLAG CHAR(1 BYTE),
SECURED_BAL NUMBER(14,4),
UNSECURED_BAL NUMBER(14,4),
NG_CHECK_FLAG CHAR(1 BYTE),
DEBIT_FLAG CHAR(1 BYTE),
FIRST_CONT_FLAG CHAR(1 BYTE),
LAST_CALL_NUM VARCHAR2(20 BYTE),
ASSIGNMENT_TYPE VARCHAR2(6 BYTE),
HEADER_NOTE VARCHAR2(300 BYTE),
PROCESS_ID_NO NUMBER(10),
UPDATE_TIME NUMBER(6),
UPDATE_DATE DATE,
UPDATE_TYPE CHAR(1 BYTE),
UPDATE_ID VARCHAR2(6 BYTE),
BAD_PHONE_FLAG CHAR(1 BYTE),
HOST_BALANCE NUMBER(14,4),
HOST_PRINCIPAL NUMBER(14,4),
HOST_INTEREST NUMBER(14,4),
HOST_COSTS NUMBER(14,4),
HOST_OTHER NUMBER(14,4),
FLAGS VARCHAR2(26 BYTE),
USER_DATE_1 DATE,
USER_DATE_2 DATE,
USER_DATE_3 DATE,
USER_DATE_4 DATE,
USER_DATE_5 DATE,
USER_NUMBER_1 NUMBER(18,4),
USER_NUMBER_2 NUMBER(18,4),
USER_NUMBER_3 NUMBER(18,4),
USER_NUMBER_4 NUMBER(18,4),
USER_NUMBER_5 NUMBER(18,4),
USER_TEXT_1 VARCHAR2(50 BYTE),
USER_TEXT_2 VARCHAR2(35 BYTE),
USER_TEXT_3 VARCHAR2(35 BYTE),
USER_TEXT_4 VARCHAR2(35 BYTE),
USER_TEXT_5 VARCHAR2(35 BYTE),
BILLED_THRU DATE,
LAST_PMT_AMT NUMBER(14,4),
ACCUM_INT_PRIN NUMBER(14,4),
ACCUM_INT_INT NUMBER(14,4),
ACCUM_INT_COST NUMBER(14,4),
ACCUM_INT_OTHER NUMBER(14,4),
BUR_UPDATE_DATE DATE,
BUR_UPDATE_TIME NUMBER(6),
CURR_ID VARCHAR2(6 BYTE) NOT NULL,
SCORE_STRATEGY VARCHAR2(6 BYTE),
TSP NUMBER(3) NOT NULL,
CRC NUMBER(10),
AGING_BUCKET1 NUMBER(18,4),
AGING_BUCKET2 NUMBER(18,4),
AGING_BUCKET3 NUMBER(18,4),
AGING_BUCKET4 NUMBER(18,4),
AGING_BUCKET5 NUMBER(18,4),
AGING_HISTORY VARCHAR2(24 BYTE),
BEHAVIOR_SCORE NUMBER(5),
CREDIT_BUR_RATING VARCHAR2(3 BYTE),
CREDIT_SCORE NUMBER(5),
CYCLES_DELQ_NOW NUMBER(3),
PAYMENT_METHOD VARCHAR2(2 BYTE),
OLDST_OUTSTNDNG_DT DATE,
TOT_COMMISSION NUMBER(14,4),
INITIAL_BALANCE NUMBER(14,4),
INITIAL_PRINCIPAL NUMBER(14,4),
INITIAL_INTEREST NUMBER(14,4),
INITIAL_COSTS NUMBER(14,4),
INITIAL_OTHER NUMBER(14,4),
STATUS_DATE DATE,
LAST_ATTEMPTS_DATE DATE,
AMT_RETURNED NUMBER(14,4),
REASON_RETURNED VARCHAR2(3 BYTE),
CLOSE_DATE DATE,
AGENCY_ACCOUNT NUMBER(14),
BUR_CC_DATE DATE,
BUR_CC_CODE VARCHAR2(2 BYTE),
BUR_CC_UPDATE_ID VARCHAR2(6 BYTE),
BUR_DT_DELINQ DATE
)

RACCTREL
(
DIVISION_ID VARCHAR2(6 BYTE) NOT NULL,
ACCOUNT VARCHAR2(20 BYTE),
REL_TYPE VARCHAR2(10 BYTE),
REL_POS VARCHAR2(2 BYTE),
P_A_ADDR_FLAG CHAR(1 BYTE),
NAME VARCHAR2(35 BYTE),
NAME_U VARCHAR2(35 BYTE),
SALUTATION VARCHAR2(35 BYTE),
ADDRESS1 VARCHAR2(35 BYTE),
ADDRESS1_U VARCHAR2(35 BYTE),
ADDRESS2 VARCHAR2(35 BYTE),
ADDRESS2_U VARCHAR2(35 BYTE),
CITY VARCHAR2(20 BYTE),
CITY_U VARCHAR2(20 BYTE),
STATE VARCHAR2(2 BYTE),
STATE_U VARCHAR2(2 BYTE),
ZIP_CODE VARCHAR2(10 BYTE),
ZIP_CODE_U VARCHAR2(10 BYTE),
COUNTY VARCHAR2(20 BYTE),
COUNTY_U VARCHAR2(20 BYTE),
COUNTRY VARCHAR2(15 BYTE),
COUNTRY_U VARCHAR2(15 BYTE),
SS_NO VARCHAR2(11 BYTE),
PHONE_HOME VARCHAR2(12 BYTE),
PHONE_WORK VARCHAR2(20 BYTE),
PHONE_OTHER VARCHAR2(20 BYTE),
DRIV_LIC_NO VARCHAR2(27 BYTE),
TIME_ZONE VARCHAR2(3 BYTE),
COMMNT VARCHAR2(30 BYTE),
UPDATE_TIME NUMBER(6),
UPDATE_DATE DATE,
UPDATE_TYPE CHAR(1 BYTE),
UPDATE_ID VARCHAR2(6 BYTE),
USER_DATE_1 DATE,
USER_DATE_2 DATE,
USER_DATE_3 DATE,
USER_DATE_4 DATE,
USER_DATE_5 DATE,
USER_NUMBER_1 NUMBER(18,4),
USER_NUMBER_2 NUMBER(18,4),
USER_NUMBER_3 NUMBER(18,4),
USER_NUMBER_4 NUMBER(18,4),
USER_NUMBER_5 NUMBER(18,4),
USER_TEXT_1 VARCHAR2(50 BYTE),
USER_TEXT_2 VARCHAR2(35 BYTE),
USER_TEXT_3 VARCHAR2(35 BYTE),
USER_TEXT_4 VARCHAR2(35 BYTE),
USER_TEXT_5 VARCHAR2(35 BYTE),
TSP NUMBER(3) NOT NULL,
CRC NUMBER(10),
BILINGUAL VARCHAR2(10 BYTE),
HO_FLAG CHAR(1 BYTE),
CON_INF_IND CHAR(1 BYTE),
USER_TEXT_6 VARCHAR2(10 BYTE)
)



> 1. It doesn't have an Oracle version number
>
> 2. It doesn't have an error message
>
> 3. It's author thinks we are going to go through the trouble of reverse
> engineering the tables just so we can help him solve his problem.
>
> If you want to debug NDS write out the final string to a text file and
> then try it in SQL*Plus.