按照教材做form出的问题，请大家帮忙

oracle11i

按照Oracle的教材做DEMORDER，上传至服务器编译后却发生了意想不到的问题，以前我在11.5.9和11.5.10的环境中多次做过这个DEMO，没有出过问题，可是这次不知道为什么，错误详细信息请看附图。

oracle11i

itpub上也有人遇到了同样的问题：
新开发的form报错


我用摸板开发了一个很简单的form，编译没有问题，
但在ERP系统里面打开的时候就报错，请问大家是什么错误啊：
FRM-47023:没有这样命名的G_QUERY_FIND参数存在于表格BSITEM中。
FRM-40105:不能解决项PAPRAMETER.G_QUERY_FIND的引用。
FRM-40700:没有这样的触发器：menu_to_appcore.
链接：http://www.itpub.net/thread-554968-1-1.html

Terence

参数PAPRAMETER.G_QUERY_FIND主要是调用手电筒查找功能时用到的，看下这方面调用有没有问题；
这个问题我遇到过好几次了，基本都是参数调用不正确引起的

oracle11i

用小手电也不能查出来package里是否调用这个参数呀

oracle11i

把做的DEMO贴上来，还没做完，半成品！我怀疑是pll库的版本的问题。

dcmkirby

good  ,ok

skyczn

以前也遇到过这个问题，解决的方法是删除那个参数再重建就没有问题了，你试一下；打开你上传的文件，报有个pll文件找不到，但是编译能通过

socc_Wlf

用標準的APSTAND.fmb來做吧

oracle11i

那个参数无法修改,无法删除,仔细看了一下编译过程:
Forms 6.0 (Form Compiler) Version 6.0.8.27.0 (Production)

Forms 6.0 (Form Compiler): Release  - Production

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
     With the Partitioning, OLAP and Oracle Data Mining options
     JServer Release 9.2.0.6.0 - Production
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.21.0 Build #0 - Production
Oracle Virtual Graphics System Version 6.0.5.39.0 (Production)
Oracle Multimedia Version 6.0.8.25.0 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
Oracle CORE Version 4.0.6.0.0 - Production
FRM-18108: Failed to load the following objects.

Source Module:APPSTAND
  Source Object: STANDARD_PC_AND_VA
Source Module:APPSTAND
  Source Object: STANDARD_TOOLBAR
Source Module:APPSTAND
  Source Object: STANDARD_CALENDAR
Compiling package specification APP_CUSTOM...
   No compilation errors.

Compiling package body APP_CUSTOM...
   No compilation errors.

Compiling procedure CHECK_PACKAGE_FAILURE...
   No compilation errors.

Compiling procedure QUERY_MASTER_DETAILS...
   No compilation errors.

Compiling procedure CLEAR_ALL_MASTER_DETAILS...
   No compilation errors.

Compiling WHEN-WINDOW-RESIZED trigger on form...
   No compilation errors.

Compiling FOLDER_ACTION trigger on form...
   No compilation errors.

Compiling FOLDER_RETURN_ACTION trigger on form...
   No compilation errors.

Compiling KEY-HELP trigger on form...
   No compilation errors.

Compiling KEY-DUPREC trigger on form...
   No compilation errors.

Compiling KEY-EXIT trigger on form...
   No compilation errors.

Compiling KEY-EDIT trigger on form...
   No compilation errors.

Compiling KEY-COMMIT trigger on form...
   No compilation errors.

Compiling KEY-CLRFRM trigger on form...
   No compilation errors.

Compiling KEY-MENU trigger on form...
   No compilation errors.

Compiling KEY-LISTVAL trigger on form...
   No compilation errors.

Compiling WHEN-WINDOW-CLOSED trigger on form...
   No compilation errors.

Compiling POST-FORM trigger on form...
   No compilation errors.

Compiling PRE-FORM trigger on form...
   No compilation errors.

Compiling ON-ERROR trigger on form...
   No compilation errors.

Compiling WHEN-NEW-FORM-INSTANCE trigger on form...
   No compilation errors.

Compiling WHEN-NEW-RECORD-INSTANCE trigger on form...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on form...
   No compilation errors.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on form...
   No compilation errors.

Compiling QUERY_FIND trigger on form...
   No compilation errors.

Compiling CLOSE_WINDOW trigger on form...
   No compilation errors.

Compiling ACCEPT trigger on form...
   No compilation errors.

Compiling ON-CLEAR-DETAILS trigger on form...
   No compilation errors.

Compiling ON-POPULATE-DETAILS trigger on ORDERS data block...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on LINES data block...
   No compilation errors.

Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in LINES data block...
   No compilation errors.


Created form file /datavg39/hbuat/apps/appl/dem/1.0.0/forms/ZHS/DEMORDER.fmx

oracle11i

FRM-18108: Failed to load the following objects.Source Module:APPSTAND,APPSTAND.fmb在服务器上同目录里有呀。

Terence

原帖由 oracle11i 于 2008-1-15 09:33 发表
FRM-18108: Failed to load the following objects.Source Module:APPSTAND,APPSTAND.fmb在服务器上同目录里有呀。

同个目录里没用，要在编译调用的Resource目录下

oracle11i

问题已解决,将APPSTAND.fmb复制到resource下，或在环境变量中的FORMS_PATH指名APPSTAND.fmb的存放目录。