| Problem in Import [message #74108] |
Mon, 13 September 2004 03:36  |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
Hi... I'm doinga user mode import... While importing I'm getting the following error after all tables are imported... Please tell me how to solve it... Just tell me if I use to view the imported tables only, will this error affect the result by any way?... I'm using Oracle8i Enterprise Edition with Windows2000 Professional....
Thanks....
Error:
IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER "MS".purchase_proposal_dtl_trig"
"before delete or update of REQUISITION_NO, ITEM_CODE, PRESENT_STOCK, ORDE"
"RING_LEVEL,"
"QTY_ORDERED"
"on purchase_proposal_dtl"
"for each row"
""
""
"declare"
"ln_srl number(6) ;"
"sta_var varchar2(1);"
"begin"
" SELECT NVL(MAX(sl_no), 0)+1 INTO ln_srl"
" FROM cmc_audit;"
" if deleting then"
" sta_var:='D' ;"
" elsif updating then"
" sta_var:='U';"
" else"
" sta_var:='I';"
" end if;"
" INSERT INTO cmc_audit"
" (sl_no,date_of_entry,table_name,action,msg,u_name,f_name)"
" VALUES"
" (ln_srl,sysdate,'purchase_proposal_dtl',sta_var,"
" nvl(:old.requisition_no,'*')||' '||"
" nvl(:old.ITEM_CODE,'*')||' '||"
" nvl(to_char(:old.PRESENT_STOCK),'*')||' '||"
" nvl(to_char(:old.ORDERING_LEVEL),'*')||' '||"
" nvl(to_char(:old.QTY_ORDERED),'*'),"
" nvl(audit_pack.u_name,'NA'),nvl(audit_pack.f_name,'NA')) ;"
" audit_pack.u_name:=null ;"
" audit_pack.f_name:=null ;"
"end ;"
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
