| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1410 Silliness
Lisa,
This is probably not true ...
Oracle doesn't, has never been able to pinpoint exact line number (in cases such as these) especially with pl/sql packages. I believe the problems can be found by executing following query ...
select line, type, source
from user_source
where name = <your package_name)
and line between 1960 and 1980
order by line, type
/
Usually in such cases (as you have described) Oracle will point to the line which contains the actual INSERT word, because for Oracle that is the LINE-OF-CODE that it is executing. Line numbers from text editors are almost always wrong.
Am I off the mark? I know the Vodka was really good, but I did drink lot of coffee too. Please correct me if I am wrong ...
Raj
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
Sent: Tuesday, December 31, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
You asked for it. Here goes. It is partitioned on julian_run_date. Please don't hammer me about the design. I wasn't given a chance to improve on it. It is basically a mainframe file that I have stored history of.
SQL> desc vegas_mart
Name Null? Type ----------------------------- -------- ------------------ ID NOT NULL NUMBER(38) CONTRACT_NUMBER NOT NULL NUMBER(9) LOAD_JOB_ID NOT NULL NUMBER(12) JULIAN_RUN_DATE NOT NULL NUMBER(12) FAC_CODE VARCHAR2(1) OWNER_LAST_NAME VARCHAR2(20) OWNER_FIRST_NAME VARCHAR2(15) OWNER_ADDRESS1 VARCHAR2(25) OWNER_ADDRESS2 VARCHAR2(25) OWNER_CITY VARCHAR2(18) OWNER_STATE VARCHAR2(2) OWNER_ZIP VARCHAR2(9) NET_PURCHASE_PRICE NUMBER(11,2) ORIGINAL_DOWN_PAYMENT NUMBER(11,2) TOTAL_DOWN_PAYMENT NUMBER(11,2) CR_BAL NUMBER(11,2) INTEREST_RATE NUMBER(5,2) FIRST_PAYMENT_DATE DATE QUALIFICATION_CODE VARCHAR2(1) PAYMENT_AMOUNT NUMBER(9,2) PAYMENT_FREQUENCY VARCHAR2(1) AGING_10_TO_30_DAYS_DUE NUMBER(9,2) AGING_31_TO_60_DAYS_DUE NUMBER(9,2) AGING_61_TO_90_DAYS_DUE NUMBER(9,2) ASSIGNED_LOAN_ADMIN_REP VARCHAR2(2) DATE_OF_SALE DATE STATUS_OF_ACCOUNT VARCHAR2(1) CONTRACT_TYPE VARCHAR2(1) WAS_PENDER VARCHAR2(1) CREDIT_LIFE_ON_CONTRACT VARCHAR2(1) DOCUMENT_STATUS_CODE VARCHAR2(1) FIXED_WEEK_SALE VARCHAR2(1) UDI_SALE VARCHAR2(1) PHASE_NUMBER VARCHAR2(6) FAIRSHARE_PLUS_MEMBER VARCHAR2(1) POINTS_OWNED NUMBER(7) DEED_DATE DATE PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1) RESERVATION_CODE VARCHAR2(4) INTERNATIONAL_CODE VARCHAR2(1) UNIT_PHASE_COMPLETION_CODE VARCHAR2(1) AGING_0_TO_90_DAYS_DUE NUMBER(9,2) AGING_91_TO_120_DAYS_DUE NUMBER(9,2) AGING_121_TO_150_DAYS_DUE NUMBER(9,2) AGING_151_OVER NUMBER(9,2) LOT_LOCATION VARCHAR2(12) PAYMENTS_MADE NUMBER(3) SUPPRESSION_CODE VARCHAR2(1) ACCRUED_INTEREST_BAL NUMBER(9,2) PAC_FREEZE_CODE VARCHAR2(1) CREDIT_CARD_FREEZE_CODE VARCHAR2(1) ASSOCIATION_NUMBER VARCHAR2(4) RFS_ASSIGNMENT_DATE DATE OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1) RESERVATION_PENDING VARCHAR2(1) CREDIT_REPORTING_CODE VARCHAR2(2) CANCEL_DEFERMENT_REASON_CODE VARCHAR2(2) EQUITY_IN NUMBER(9,2) DATE_CODED_7 DATE ADJUSTABLE_RATE_MORTGAGE VARCHAR2(1) NUMBER_OF_PAYS_LEFT NUMBER(4) DEFERRED_INTEREST NUMBER(9,2) DEFERRED_PRINCIPAL NUMBER(9,2) CURRENT_YEAR_DEFERMENTS NUMBER(5) CURRENT_YEAR_TOTAL_DEFERMENTS NUMBER(5) LAST_PAYMENT_DATE DATE NEXT_PAYMENT_DATE DATE PAC_DUE_DATE DATE EFT_ROUTING_NUMBER VARCHAR2(8) EFT_ACCOUNT_NUMBER VARCHAR2(30) EFT_MANUAL_NUMBER VARCHAR2(30) BANK VARCHAR2(35) STATUS_CHANGE_DATE DATE ASSIGNED_LOAN_REP VARCHAR2(2) CREDIT_CARD_PAC_ACCOUNT VARCHAR2(20) PRINCIPAL_BALANCE NUMBER(11,2) CR_DISCOUNT_BALANCE NUMBER(11,2) CREDIT_LIFE_PREM_BAL NUMBER(11,2) RFP_PAC_CODE VARCHAR2(1) RFP_DRAFT_CODE VARCHAR2(1) RFP_ROUTE_NUMBER VARCHAR2(8) RFP_EFT_NUMBER VARCHAR2(30) RFP_MANUAL_NUMBER VARCHAR2(30) RFP_BANK_NAME VARCHAR2(35) FPPA_PAC_CODE VARCHAR2(1) FPPA_DRAFT_CODE VARCHAR2(1) FPPA_ROUTE_NUMBER VARCHAR2(8) FPPA_EFT_NUMBER VARCHAR2(30) FPPA_MANUAL_NUMBER VARCHAR2(30) FPPA_BANK_NAME VARCHAR2(35) TS_BAL_DUE_RECOGNIZED NUMBER(9) TS_LATE_FEE_RECOGNIZED NUMBER(9,2) TS_YTD_MAINT_FEE_COLL NUMBER(9,2) TS_MAINT_FEE_AMOUNT NUMBER(9,2) PO_BIRTH_DATE DATE TS_LOCATION VARCHAR2(12) CR_DATE_REC_IN_DEEDING DATE CR_REFUND VARCHAR2(11) CR_CREDIT_LIFE_TYPE VARCHAR2(1) CR_QUALIFICATION_DATE DATE CR_EQT_IN_FROM_CONT_NO1 VARCHAR2(9) CR_EQT_IN_FROM_CONT_NO2 VARCHAR2(9) CR_HC_AMT1 NUMBER(9) CR_HC_AMT2 NUMBER(9) CR_HC_POST1 NUMBER(9) CR_HC_POST2 NUMBER(9) CR_HC_DATE1 DATE CR_HC_DATE2 DATE CR_DATE_IN_LR DATE CR_TRADE_ALLOW NUMBER(9) CR_TITLE_INS_CHARGED NUMBER(11) CR_TITLE_INS_COLLECTED NUMBER(11) CR_FILING_FEE_CHARGED NUMBER(11) CR_FILING_FEE_COLLECTED NUMBER(11) CR_ACCRUED_INT_BAL_RSV NUMBER(11) CR_LATE_FEE_BAL_RSV NUMBER(11) AREA_CODE VARCHAR2(3) PHONE_NUMBER VARCHAR2(7) PAID_OFF VARCHAR2(1) EDIT_DATE_TIME DATE BIANNUAL_FLAG VARCHAR2(10) FICO_SCORE NUMBER(3) SOCIAL_SECURITY_NUMBER NUMBER(9)
SQL> Here's the code. Line 1970 is cr_hc_amt2.
Makes no sense at all. And if you read this far, don't say I didn't warn you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jamadagni, Rajendra
INET: Rajendra.Jamadagni_at_espn.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |