Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » invalid object
invalid object [message #137532] Thu, 15 September 2005 08:05
roets
Messages: 1
Registered: September 2005
Location: Brussels
Junior Member
During the import of a database, we were left with 45 additional invalid object, due to compilation warning during the import.
They are all belonging to FLOW_010500, version 1.5 and FLOW_010500, version 1.6 of html db. Version 1.6 is of this product is also installed.
the version 1.5 schema is left on the system as a downgrade feature, so most prob. not used anymore.
We are migrating from
Thru 64 Unix version 5.1B, oracle version 9.2.0.4.0 towards HPUX B.11.23 U ia64, oracle version 9.2.0.6.0 - 64bit Production
The customer wants exactly the same db's and is wondering from where those error come.

catalog, catproc, catpatch and utlrp did not fix it.
Any Idea ?

Chris

45 IMP-00041: Warning: object created with compilation warnings

FLOWS_010500 WWV_EXECUTE_IMMEDIATE
FLOWS_010500 WWV_FLOW_AUDIT
FLOWS_010500 WWV_FLOW_BUILDER
FLOWS_010500 WWV_FLOW_DATALOAD_XML
FLOWS_010500 WWV_FLOW_IMP_PARSER
FLOWS_010500 WWV_FLOW_LOAD_DATA
FLOWS_010500 WWV_FLOW_SVG
FLOWS_010500 WWV_FLOW_SW_UTIL
FLOWS_010500 WWV_FLOW_UPGRADE
FLOWS_010500 WWV_XML_UTIL
FLOWS_010500 WWV_XML_UTIL
FLOWS_010500 WWV_RENDER_REPORT3
FLOWS_010500 WWV_RENDER_CHART2
FLOWS_010500 WWV_RENDER_CALENDAR2
FLOWS_010500 WWV_FLOW_XLIFF
FLOWS_010500 WWV_FLOW_WIZARD_API
FLOWS_010500 WWV_FLOW_UTILITIES
FLOWS_010500 WWV_FLOW_TEMP
FLOWS_010500 WWV_FLOW_SW_API
FLOWS_010500 WWV_FLOW_QUERY
FLOWS_010500 WWV_FLOW_ITEM
FLOWS_010500 WWV_FLOW_DISP_PAGE_PLUGS
FLOWS_010500 WWV_FLOW_COLLECTION
FLOWS_010600 WWV_EXECUTE_IMMEDIATE
FLOWS_010600 WWV_FLOW_IMP_PARSER
FLOWS_010600 WWV_RENDER_REPORT3
FLOWS_010600 WWV_RENDER_CHART2
FLOWS_010600 WWV_RENDER_CALENDAR2
FLOWS_010600 WWV_FLOW_XLIFF
FLOWS_010600 WWV_FLOW_WIZARD_API
FLOWS_010600 WWV_FLOW_UTILITIES
FLOWS_010600 WWV_FLOW_UPGRADE
FLOWS_010600 WWV_FLOW_TEMP
FLOWS_010600 WWV_FLOW_SW_UTIL
FLOWS_010600 WWV_FLOW_SW_API
FLOWS_010600 WWV_FLOW_SVG
FLOWS_010600 WWV_FLOW_QUERY
FLOWS_010600 WWV_FLOW_SW_API
FLOWS_010600 WWV_FLOW_SVG
FLOWS_010600 WWV_FLOW_QUERY
FLOWS_010600 WWV_FLOW_LOAD_DATA
FLOWS_010600 WWV_FLOW_ITEM
FLOWS_010600 WWV_FLOW_FORM_CONTROL
FLOWS_010600 WWV_FLOW_AUDIT
FLOWS_010600 WWV_FLOW_CALENDAR3
FLOWS_010600 WWV_FLOW_COLLECTION
FLOWS_010600 WWV_FLOW_DISP_PAGE_PLUGS
FLOWS_010600 WWV_FLOW_BUILDER


45 rows selected.

here is an example :
(The rest are in attached file)

IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "FLOWS_010500"."WWV_FLOW_FILES" ("ID","
""FLOW_ID","NAME","FILENAME","TITLE","MIME_TYPE","DOC_SIZE","DAD_CHARSET","C"
"REATED_BY","CREATED_ON","UPDATED_BY","UPDATED_ON","LAST_UPDATED","CONTENT_T"
"YPE","BLOB_CONTENT","LANGUAGE","DESCRIPTION","FILE_TYPE","FILE_CHARSET") AS"
" "
"select id, flow_id, name, filename, title, mime_type, doc_size, dad_charset"
","
" created_by, created_on, updated_by, updated_on, last_updated, cont"
"ent_type,"
" blob_content, language, description, file_type, file_charset"
" from wwv_flow_file_objects$"
" where security_group_id = wwv_flow.get_sgid"



Previous Topic: HtmlDb - automatic logout after NN minutes?
Next Topic: Need help in creating a tree page in htmldb
Goto Forum:
  


Current Time: Sun Feb 25 09:35:01 CST 2024