Home » Developer & Programmer » Forms » push button
icon12.gif  push button [message #175927] Tue, 06 June 2006 02:15 Go to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

hi friends,
i am new with forms 10g. i developed few forms in forms6 with push buttons to browse my local directory to call any picture file to display or fetch into database, and it was working well with Forms6.
Now i'm trying to run the same form in forms10g (on web), the form is running good but the push button is not working, i keep pressing the button but no reaction.
i have written the following code on when-button-pressed for the push button:
declare
dirname varchar2(255);
v_filename varchar2(255);
begin
tool_env.getvar('c:\', dirname);
dirname := dirname || '\bin\bmp';

v_filename := get_file_name(dirname,NULL,
'All Files (*.*)|*.*|' ||
'JPEG Files (*.jpg)|*.jpg|' ||
'Bitmap Files (*.bmp)|*.bmp|' ||
'TIFF Files (*.tif)|*.tif|' ||
'CompuServe Files (*.gif)|*.gif|' ||
'PC Paintbrush Files (*.pcx)|*.pcx|' );

if v_filename is not null then
read_image_file(v_filename,'ANY','pp_foto.foto');
end if;
end;

can anyone help me to solve this problem???...

regards..
Re: push button [message #175948 is a reply to message #175927] Tue, 06 June 2006 03:22 Go to previous messageGo to next message
Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan
Member

You will you webutil.pll and replace get_file_name with Client_Get_File_Name


Best regards
R E H A N M I R Z A
Re: push button [message #175982 is a reply to message #175948] Tue, 06 June 2006 05:06 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

thanks rehan,
can u plz tell me in brief, what to do with webutil.pll. and while replacing get_file_name with Client_Get_File_Name, it gives me compilation error "identifier client_get_file_name must be declared"

best regards..
Re: push button [message #175992 is a reply to message #175927] Tue, 06 June 2006 05:30 Go to previous messageGo to next message
Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan
Member

You need to attached webutil.pll in yours form

Best regards
R E H A N M I R Z A
Re: push button [message #176018 is a reply to message #175982] Tue, 06 June 2006 07:03 Go to previous messageGo to next message
ahmad_uaf
Messages: 68
Registered: March 2006
Location: Pakistan
Member

Hello,
First a suggestion plz. calarify your subject to understand easily the matter. This is not a problamtic subject.........PUSH BUTTON.........right
second i will send u a attachment.Afer reading this u easily understand the function and configuration of webutil.pll.
OK
Regards,
Ahmad
  • Attachment: web_util.pdf
    (Size: 1.12MB, Downloaded 5051 times)
Re: push button [message #176104 is a reply to message #176018] Wed, 07 June 2006 00:20 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

thanks ahmad
dear things were going right but i stuck while downloading jacob_18.zip, i couldn't download it correctly, giving me some error. so is it for you or anyone to send me jacob_18.zip that will be your most kindness.
best regards
Re: push button [message #176244 is a reply to message #176104] Wed, 07 June 2006 08:48 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

i am running this form on devlopement machine and am using developer suite10g(9.0.4.0.1). and the library i attached is webutil Release 1.0.6 and jacob_18 as a runtime component which is mentioned in webutil doc.
I think the problem is with configuring webutil and for the configuring of webutil i follow the webutil doc.
and now i am getting any compilation error but when i am pressing the push button at the runtime it gives me error "FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508". I want to mention here that i am using only one item on the canvas for testing and the code i am using is:
declare
dirname varchar2(255);
photo_filename varchar2(255);
begin
client_tool_env.getvar('G:\', dirname);
dirname := dirname || '\reyaz';

photo_filename := client_get_file_name(dirname,NULL, 'All Files (*.*)|*.*|');

/* if photo_filename is not null then

READ_IMAGE_FILE(photo_filename, 'any', 'IMAGE_BLOCK.MY_IMAGE');

end if;
exception
when others then
dbms_output.put_line('hi');*/
end;

need your help to solve this problem.

thanks
Re: push button [message #176596 is a reply to message #176244] Thu, 08 June 2006 19:50 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do you know exactly which statement is returning the error. IF not, then put 'message('asdf'); pause;' pairs between each line and find out.

David
icon12.gif  Re: push button [message #177936 is a reply to message #176596] Sun, 18 June 2006 03:36 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

hi,

now i get Dev. suite 10g Release 2. now i don't need to configure webutil becaue it is already configured by default. so only i did is to configure jacob.

but now i am getting error "FRM-40039: Cannot attach library <ora_Home>\forms\webutil while opening form buttontest."

where & what is wrong now??
Re: push button [message #177982 is a reply to message #177936] Sun, 18 June 2006 21:37 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you run the webutil demo? Have you read its documentation? Have you put the files in the correct directories (they are listed in the doco.)? Have you put the directory names into the registry entries (they are also in the doco.)?

David
Re: push button [message #178027 is a reply to message #177982] Mon, 19 June 2006 02:49 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

hi David
i am using Dev. Suite 10G Release 2 and webutil is auto configured in 10g release-2.
i also read the webutil doc and it is configured correctly. and i also configure jacob files as mentioned in webutil doc.

working fine but i'm getting now "FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508" error at the runtime.
it is mentioned in webutil doc that, you must regenerate webutil.pll before using it; otherwise you’ll encounter error ORA-06508 when running a form with the attached library.
but when i am trying to recompile webutil.pll using userid=scott/tiger@db10g, getting compilation errors as "WEBUTIL_DB.OPENBLOB, WEBUTIL_DB.CLOSEBLOB, etc. must be declared"

[Updated on: Mon, 19 June 2006 04:59]

Report message to a moderator

Re: push button [message #178373 is a reply to message #178027] Tue, 20 June 2006 20:32 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Does the 'scott' userid have access to the webutil_db objects?

David
Re: push button [message #178451 is a reply to message #178373] Wed, 21 June 2006 03:37 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

i compiled the webutil.pll successfully and everything is ok now but at the run time when i press the button i am getting "oracle.forms.webutil.host.Host bean not found. WEBUTIL_HOST.Execute will not work" error
Re: push button [message #178821 is a reply to message #178451] Thu, 22 June 2006 23:34 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I googled 'WEBUTIL_HOST Execute will not work' and found http://forums.oracle.com/forums/thread.jspa?messageID=1332297

Does this help?

David
Re: push button [message #179041 is a reply to message #178821] Sat, 24 June 2006 02:49 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

it is mentioned there to use HOST command, but sorry to say i don't know to use HOST command. i mean, i am working on win-XP SP2 platform and my sample form has only one push button(browse) with code as below on when-button-pressed trigger:

declare
dirname varchar2(255);
v_filename varchar2(255);
begin
client_tool_env.getvar('c:\', dirname);
dirname := dirname || '\bin\bmp';

v_filename := client_get_file_name(dirname,NULL,
'All Files (*.*)|*.*|' ||
'JPEG Files (*.jpg)|*.jpg|' ||
'Bitmap Files (*.bmp)|*.bmp|' ||
'TIFF Files (*.tif)|*.tif|' ||
'CompuServe Files (*.gif)|*.gif|' ||
'PC Paintbrush Files (*.pcx)|*.pcx|' );

if v_filename is not null then
read_image_file(v_filename,'ANY','pp_foto.foto');
end if;
end;

So, where to use HOST command to run this form correctly without getting "oracle.forms.webutil.host.Host bean not found. WEBUTIL_HOST.Execute will not work" error.
Re: push button [message #179137 is a reply to message #179041] Sun, 25 June 2006 23:58 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I repeat "Have you run the webutil demo?"

David
Re: push button [message #179145 is a reply to message #179041] Mon, 26 June 2006 00:47 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

yes i run the webutil demo, but i get the same type of errors there (...Host bean not found WEBUTIL_HOST.Execute will not work)
Re: push button [message #179151 is a reply to message #179145] Mon, 26 June 2006 01:39 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you gone through the http://www.oracle.com/technology/products/forms/htdocs/webutil/web_util.pdf document?

Please paste your formsweb.cfg.

Have a look at http://www.oracle.com/technology/products/forms/htdocs/webutil/simplifiedWebUtil.html

David
Re: push button [message #179158 is a reply to message #179151] Mon, 26 June 2006 02:23 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

yes already gone through web_util.pdf and other doc.

here is my formsweb.cfg file:

# $Id: formsweb.cfg 15-apr-2005.13:17:30 pkuhn Exp $
# formsweb.cfg defines parameter values used by the FormsServlet (frmservlet)
# This section defines the Default settings. Any of them may be overridden in the
# following Named Configuration sections. If they are not overridden, then the
# values here will be used.
# The default settings comprise two types of parameters: System parameters,
# which cannot be overridden in the URL, and User Parameters, which can.
# Parameters which are not marked as System parameters are User parameters.
# SYSTEM PARAMETERS
# -----------------
# These have fixed names and give information required by the Forms
# Servlet in order to function. They cannot be specified in the URL query
# string. But they can be overridden in a named configuration (see below).
# Some parameters specify file names: if the full path is not given,
# they are assumed to be in the same directory as this file. If a path
# is given, then it should be a physical path, not a URL.
# USER PARAMETERS
# ---------------
# These match variables (e.g. %form%) in the baseHTML file. Their values
# may be overridden by specifying them in the URL query string
# (e.g. "http://myhost.mydomain.com/forms/frmservlet?form=myform&width=700")
# or by overriding them in a specific, named configuration (see below)
[default]
# System parameter: default base HTML file
baseHTML=base.htm,webutilbase.htm.
# System parameter: base HTML file for use with JInitiator client
baseHTMLjinitiator=basejini.htm
# System parameter: base HTML file for use with Sun's Java Plug-In
baseHTMLjpi=basejpi.htm
# System parameter: delimiter for parameters in the base HTML files
HTMLdelimiter=%
# System parameter: working directory for Forms runtime processes
# WorkingDirectory defaults to <oracle_home>/forms if unset.
workingDirectory=
# System parameter: file setting environment variables for the Forms runtime processes
envFile=default.env

# Forms runtime argument: whether to escape certain special characters
# in values extracted from the URL for other runtime arguments
escapeparams=true
# Forms runtime argument: which form module to run
form=test.fmx
# Forms runtime argument: database connection details
userid=
# Forms runtime argument: whether to run in debug mode
debug=no
# Forms runtime argument: host for debugging
host=
# Forms runtime argument: port for debugging
port=
# Other Forms runtime arguments: grouped together as one parameter.
# These settings support running and debugging a form from the Builder:
otherparams=buffer_records=%buffer% debug_messages=%debug_messages% array=%array% obr=%obr% query_only=%query_only% quiet=%quiet% render=%render% record=%record% tracegroup=%tracegroup% log=%log% term=%term%
# Sub argument for otherparams
buffer=no
# Sub argument for otherparams
debug_messages=no
# Sub argument for otherparams
array=no
# Sub argument for otherparams
obr=no
# Sub argument for otherparams
query_only=no
# Sub argument for otherparams
quiet=yes
# Sub argument for otherparams
render=no
# Sub argument for otherparams
record=
# Sub argument for otherparams
tracegroup=
# Sub argument for otherparams
log=
# Sub argument for otherparams
term=

# HTML page title
pageTitle=Reyaz's Oracle Application Server Forms Services
# HTML attributes for the BODY tag
HTMLbodyAttrs=
# HTML to add before the form
HTMLbeforeForm=
# HTML to add after the form
HTMLafterForm=

# Forms applet parameter: URL path to Forms ListenerServlet
serverURL=/forms/lservlet
# Forms applet parameter
codebase=/forms/java
# Forms applet parameter
imageBase=DocumentBase
# Forms applet parameter
width=750
# Forms applet parameter
height=600
# Forms applet parameter
separateFrame=false
# Forms applet parameter
splashScreen=
# Forms applet parameter
background=
# Forms applet parameter
lookAndFeel=Oracle
# Forms applet parameter
colorScheme=teal
# Forms applet parameter
logo=
# Forms applet parameter
restrictedURLparams=HTMLbodyAttrs,HTMLbeforeForm,pageTitle,HTMLafterForm,log,allow_debug,allowNewConnections
# Forms applet parameter
formsMessageListener=
# Forms applet parameter
recordFileName=
# Forms applet parameter
serverApp=default
# Forms applet archive setting for JInitiator
archive_jini=frmall_jinit.jar
# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
archive=frmall.jar
# Number of times client should retry if a network failure occurs. You should
# only change this after reading the documentation.
networkRetries=0

# Page displayed to Netscape users to allow them to download Oracle JInitiator.
# Oracle JInitiator is used with Windows clients.
# If you create your own page, you should set this parameter to point to it.
jinit_download_page=/forms/jinitiator/us/jinit_download.htm
# Parameter related to the version of JInitiator
jinit_classid=clsid:CAFECAFE-0013-0001-0022-ABCDEFABCDEF
# Parameter related to the version of JInitiator
jinit_exename=jinit.exe#Version=1,3,1,22
# Parameter related to the version of JInitiator
jinit_mimetype=application/x-jinit-applet;version=1.3.1.22

# Page displayed to users to allow them to download Sun's Java Plugin.
# Sun's Java Plugin is typically used for non-Windows clients.
# (NOTE: you should check this page and possibly change the settings)
jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html
# Parameter related to the version of the Java Plugin
jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin
jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06
# EM config parameter
# Set this to "1" to enable Enterprise Manager to track Forms processes
em_mode=0

# Single Sign-On OID configuration parameter
oid_formsid=%OID_FORMSID%
# Single Sign-On OID configuration parameter
oracle_home=F:\DevS10g
# Single Sign-On OID configuration parameter
formsid_group_dn=%GROUP_DN%
# Single Sign-On OID configuration parameter: indicates whether we allow
# dynamic resource creation if the resource is not yet created in the OID.
ssoDynamicResourceCreate=true
# Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false
ssoErrorUrl=
# Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.
ssoCancelUrl=
# Single Sign-On parameter: indicates whether the url is protected in which
# case mod_osso will be given control for authentication or continue in
# the FormsServlet if not. It is false by default. Set it to true in an
# application-specific section to enable Single Sign-On for that application.
ssoMode=false
# The parameter allow_debug determines whether debugging is permitted.
# Administrators should set allow_debug to "true" if servlet
# debugging is required, or to provide access to the Forms Trace Xlate utility.
# Otherwise these activities will not be allowed (for security reasons).
allow_debug=false
# Parameter which determines whether new Forms sessions are allowed.
# This is also read by the Forms EM Overview page to show the
# current Forms status.
allowNewConnections=true

# EndUserMonitoring

# EndUserMonitoringEnabled parameter
# Indicates whether EUM/Chronos integration is enabled
EndUserMonitoringEnabled=

# EndUserMonitoringURL
# indicates where to record EUM/Chronos data
EndUserMonitoringURL=

# Example Named Configuration Section
# Example 1: configuration to run forms in a separate browser window with
# "generic" look and feel (include "config=sepwin" in the URL)
# You may define your own specific, named configurations (sets of parameters)
# by adding special sections as illustrated in the following examples.
# Note that you need only specify the parameters you want to change. The
# default values (defined above) will be used for all other parameters.
# Use of a specific configuration can be requested by including the text
# "config=<your_config_name>" in the query string of the URL used to run
# a form. For example, to use the sepwin configuration, your could issue
# a URL like "http://myhost.mydomain.com/forms/frmservlet?config=sepwin".
[sepwin]
separateFrame=True
lookandfeel=Generic

# Example Named Configuration Section
# Example 2: configuration forcing use of the Java Plugin in all cases (even if
# the client browser is on Windows)
[jpi]
baseHTMLJInitiator=basejpi.htm

# Example Named Configuration Section
# Example 3: configuration running the Forms ListenerServlet in debug mode
# (debug messages will be written to the servlet engine's log file).
[debug]
serverURL=/forms/lservlet/debug

# Sample configuration for deploying WebUtil. Note that WebUtil is shipped with
# DS but not AS and is also available for download from OTN.
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
archive=frmall.jar
lookAndFeel=oracle

Re: push button [message #179164 is a reply to message #179158] Mon, 26 June 2006 02:45 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Compare yours against this one
# $Id: formsweb.cfg,v 1.23 2002/01/25 06:51:41 oraforms Exp $
# -------------------------------------------------------
# formsweb.cfg - Forms Servlet default configuration file
# -------------------------------------------------------
# This file defines parameter values used by the FormsServlet (f90servlet)

# ********************************
# DEFAULT CONFIGURATIONS
# ********************************
#
# These are the default settings.  Any of them may be overridden in the
# Named Configurations section.  If they are not overridden, then the
# values here will be used.
# System Paremeters cannot be overridden in the URL.  User Parameters can.
#

#
# SYSTEM PARAMETERS
# -----------------
# These have fixed names and give information required by the Forms 
# Servlet in order to function.  They cannot be specified in the URL query 
# string.  But they can be overriden in a named configuration (see below).
# Some parameters specify file names: if the full path is not given,
# they are assumed to be in the same directory as this file.  If a path
# is given, then it should be a physical path, not a URL.
#
# 30/08/2004 DJMartin baseHTML entries to try and get Webutil working from Forms Builder
#baseHTML=base.htm
#baseHTMLjinitiator=basejini.htm
#baseHTMLjpi=basejpi.htm
#baseHTMLie=baseie.htm
baseHTML=D:\Oracle\Ora9i\forms90\webutil\server\webutilbase.htm
baseHTMLjinitiator=D:\Oracle\Ora9i\forms90\webutil\server\webutiljini.htm
baseHTMLjpi=D:\Oracle\Ora9i\forms90\webutil\server\webutiljpi.htm
baseHTMLie=D:\Oracle\Ora9i\forms90\webutil\server\webutilbase.htm

HTMLdelimiter=%

#
# WorkingDirectory defaults to <oracle_home>/forms90 if unset.
#
workingDirectory=
envFile=default.env

#
# The next parameter specifies how to execute the Forms applet under 
# Microsoft Internet Explorer 5.x.  Put IE=native if you want the
# Forms applet to run in the browser's native JVM.
#
IE=JInitiator

#
# USER PARAMETERS
# ---------------  
# These match variables (e.g. %form%) in the baseHTML file. Their values 
# may be overridden by specifying them in the URL query string
# (e.g. "http://myhost.mydomain.com/servlet/f90servlet?form=myform&width=700")
# or by overriding them in a specific, named configuration (see below)
#

#
# 1) Runform arguments:
#
form=test.fmx
userid=

#
# These settings support running and debugging a form from the Builder:
#
### The following 3 lines were broken for display purposes only!!
otherparams=debug=%debug% buffer_records=%buffer% debug_messages=%debug_messages%
   array=%array% query_only=%query_only% quiet=%quiet% render=%render% host=%host%
   port=%port% record=%record% tracegroup=%tracegroup% log=%log% term=%term%
debug=no
buffer=no
debug_messages=no
array=no
query_only=no
quiet=yes
render=no
host=
port=
record=
tracegroup=
log=
term=

#
# 2) HTML page title, attributes for the BODY tag, and HTML to add before and 
#    after the form:
#
ageTitle=Oracle9iAS Forms Services
HTMLbodyAttrs=
HTMLbeforeForm=
HTMLafterForm=

#
# 3) Values for the Forms applet parameters:
#
serverURL=/forms90/l90servlet
codebase=/forms90/java
imageBase=DocumentBase
width=850
height=700
separateFrame=false
splashScreen=
background=
lookAndFeel=Oracle
colorScheme=blue
logo=
formsMessageListener=
recordFileName=

serverApp=default

#
# The following archive settings are for
#   archive_jini - settings for JInitiator
#   archive_ie   - settings for IE native JVM
#   archive      - settings for all other cases (Java Plugin, Appletviewer, etc)
#
archive_jini=f90all_jinit.jar
archive_ie=f90all.cab
archive=f90all.jar


#
# Number of times client should retry if a network failure occurs.  Only
# change after having read the documentation.
#
networkRetries=0

#
# 4) Parameters for JInitiator (used with Windows clients)
#

#
# Page displayed to Netscape users to allow them to download JInitiator.  
# If you create your own page, you should set this parameter to point to it.
#
jinit_download_page=/forms90/jinitiator/us/jinit_download.htm

#
# Parameters related to the version of JInitiator.
#
jinit_classid=clsid:CAFECAFE-0013-0001-0018-ABCDEFABCDEF
jinit_exename=jinit.exe#Version=1,3,1,18
jinit_mimetype=application/x-jinit-applet;version=1.3.1.18

#
# 5) Parameters for the Java Plugin (used with non-Windows clients)
#

#
# Page displayed to users to allow them to download the JPI
# (NOTE: you should check this page and possibly change the settings)
#
jpi_download_page=http://java.sun.com/products/plugin/1.3/plugin-install.html

#
# Parameters related to the version of the Java Plugin
#
jpi_classid=clsid:8AD9C840-044E-11D1-B3E9-00805F499D93
jpi_codebase=http://java.sun.com/products/plugin/1.3/jinstall-13-win32.cab#Version=1,3,0,0
jpi_mimetype=application/x-java-applet;version=1.3

#
# 6) EM config parameter
# Set this to "1" to enable Enterprise Manager to track Forms processes
#
em_mode=0

#
# 6) OID Config parameters (for Single Sign-On)
#
oid_formsid=%OID_FORMSID%
oracle_home=D:\Oracle\Ora9i

# 30/08/2004 DJMartin Put WebUtil stuff here to try and get Webutil working from Forms Builder
webUtilArchive=/forms90/webutil/webutil.jar,/forms90/webutil/jacob.jar
WebUtilLogging=off
#WebUtilLogging=ALL
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
#WebUtilErrorMode=ALL


#
# 7) Webutil and Jacob stuff - Monday 23 August 2004
#
#A sample config entry for use with WebUtil
[webutil]
separateFrame=false
form=WU_TEST.fmx
userid=webutil/webutil@bxd.world
webUtilArchive=/forms90/webutil/webutil.jar,/forms90/webutil/jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
baseHTMLjinitiator=D:\Oracle\Ora9i\forms90\webutil\server\webutiljini.htm
baseHTMLjpi=D:\Oracle\Ora9i\forms90\webutil\server\webutiljpi.htm
archive_jini=f90all_jinit.jar
archive=f90all.jar
lookAndFeel=oracle
width=100%
height=100%
#envFile=D:\Oracle\Ora9i\forms90\webutil\server\webutil.env


#[webutilie]
#IE=native
#webUtilArchive=/forms90/webutil/webutil.jar,/forms90/webutil/jacob.jar
#WebUtilLogging=off
#WebUtilLoggingDetail=normal
#baseHTML=D:\Oracle\Ora9i\forms90\webutil\server\webutilbase.htm
#baseHTMLie=D:\Oracle\Ora9i\forms90\webutil\server\webutilbase.htm
#archive=f90all.jar
#lookAndFeel=oracle
#width=100%
#height=100%
#envFile=D:\Oracle\Ora9i\forms90\webutil\server\webutil.env
#
#[webutiljpi]
#webUtilArchive=/forms90/webutil/webutil.jar,/forms90/webutil/jacob.jar
#WebUtilLogging=off
#WebUtilLoggingDetail=normal
#WebUtilErrorMode=Alert
#baseHTMLjinitiator=D:\Oracle\Ora9i\forms90\webutil\server\webutiljpi.htm
#baseHTMLjpi=D:\Oracle\Ora9i\forms90\webutil\server\webutiljpi.htm
#baseHTMLie=D:\Oracle\Ora9i\forms90\webutil\server\webutiljpi.htm
#baseHTML=D:\Oracle\Ora9i\forms90\webutil\server\webutiljpi.htm
#archive=f90all.jar
#lookAndFeel=oracle
#width=100%
#height=100%
#envFile=D:\Oracle\Ora9i\forms90\webutil\server\webutil.env


# ********************************
# NAMED CONFIGURATIONS
# ********************************
#
#  You may define your own specific, named configurations (sets of parameters)
#  by adding special sections as illustrated in the following examples.  
#  Note that you need only specify the parameters you want to change.  The 
#  default values (defined above) will be used for all other parameters.
#  Use of a specific configuration can be requested by including the text 
#  "config=<your_config_name>" in the query string of the URL used to run
#  a form.  For example, to use the sepwin configuration, your could issue
#  a URL like "http://myhost.mydomain.com/servlet/f90servlet?config=sepwin".
#

#
# Example 1: configuration to run forms in a separate browser window with 
#            "generic" look and feel (include "config=sepwin" in the URL)
#
[sepwin]
separateFrame=True
lookandfeel=Generic

#
# Example 2: configuration affecting users of MicroSoft Internet Explorer 5.x.
#            Forms applet will run under the browser's native JVM rather than 
#            using Oracle JInitiator.
#
[ienative]
IE=native

#
# Example 3: configuration forcing use of the Java Plugin in all cases
#            (even if the client browser is on Windows)
#
[jpi]
baseHTMLJInitiator=basejpi.htm
baseHTMLie=basejpi.htm

#
# Example 4: configuration running the Forms ListenerServlet in debug mode 
#            (debug messages will be written to the servlet engine's log file)
#
[debug]
serverURL=/forms90/l90servlet/debug

#
# Department of xxx - Development
#
[xxx]
separateFrame=false
form=Dp_stat.fmx
userid=xxx/@xxx.world
width=713
height=606
colorScheme=Titanium
align=baseline
#splashScreen=logo_frame.gif
webformsTitle="DP Statistics"
Logo=yes
#serverApp=/regico/Ctrackregistry
#Background=NO

You will see that the order is a little different, and the 'baseHTML' entries are NOT in a labeled area. Also, there is only ONE page per entry. This could be your problem.

David

[Updated on: Mon, 26 June 2006 20:08]

Report message to a moderator

Re: push button [message #179270 is a reply to message #179164] Mon, 26 June 2006 10:21 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

Hi David,
I compare your formsweb.cfg with mine but no change, still getting the same error.

but i couldn't find archive_ie=f90all.cab entry in my formsweb.cfg, then i search for frmall.cab (i am using Dev. Suite10g R2) on my pc but no result.
Re: push button [message #179316 is a reply to message #179270] Mon, 26 June 2006 20:05 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Okay ... do a search for '*all.cab'

David
Re: push button [message #179338 is a reply to message #179316] Tue, 27 June 2006 00:48 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member


i didn't find any file with *all.cab or *.cab, but there is one 'frmall.jar' file & it's entry is already there in formsweb.cfg as 'archive=frmall.jar'

Still same type of errors
Re: push button [message #179577 is a reply to message #179338] Wed, 28 June 2006 01:58 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You have "oracle_home=F:\DevS10g" and "WebUtilArchive=frmwebutil.jar,jacob.jar"

I have "oracle_home=D:\Oracle\Ora9i" and "webUtilArchive=/forms90/webutil/webutil.jar,/forms90/webutil/jacob.jar"

This means my 'jacob.jar' is in 'D:\Oracle\Ora9i/forms90/webutil' and yours is in 'F:\DevS10g'. Is this true on your part?

David

[Updated on: Wed, 28 June 2006 01:58]

Report message to a moderator

Re: push button [message #179643 is a reply to message #179577] Wed, 28 June 2006 05:15 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

my 'jacob.jar' is in 'F:\DevS10g\forms\java' and also in 'F:\DevS10g\forms\webutil'
Re: push button [message #179806 is a reply to message #179643] Wed, 28 June 2006 18:13 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Then put the extra sub-directory name into your configuration file.

David
Re: push button [message #180430 is a reply to message #179806] Mon, 03 July 2006 08:44 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

I do what you said, but same error
Re: push button [message #180705 is a reply to message #180430] Tue, 04 July 2006 21:27 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Okay, post your formsweb.cfg file again.

David
Re: push button [message #180729 is a reply to message #180705] Wed, 05 July 2006 01:04 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

My original formsweb.cfg file:
# $Id: formsweb.cfg 15-apr-2005.13:17:30 pkuhn Exp $
# formsweb.cfg defines parameter values used by the FormsServlet (frmservlet)
# This section defines the Default settings.  Any of them may be overridden in the
# following Named Configuration sections.  If they are not overridden, then the
# values here will be used.
# The default settings comprise two types of parameters: System parameters,
# which cannot be overridden in the URL, and User Parameters, which can.
# Parameters which are not marked as System parameters are User parameters.
# SYSTEM PARAMETERS
# -----------------
# These have fixed names and give information required by the Forms
# Servlet in order to function.  They cannot be specified in the URL query
# string.  But they can be overridden in a named configuration (see below).
# Some parameters specify file names: if the full path is not given,
# they are assumed to be in the same directory as this file.  If a path
# is given, then it should be a physical path, not a URL.
# USER PARAMETERS
# ---------------
# These match variables (e.g. %form%) in the baseHTML file. Their values
# may be overridden by specifying them in the URL query string
# (e.g. "[url]http://myhost.mydomain.com/forms/frmservlet?form=myform&width=700[/url]")
# or by overriding them in a specific, named configuration (see below)
[default]
# System parameter: default base HTML file
baseHTML=base.htm,webutilbase.htm
# System parameter: base HTML file for use with JInitiator client
baseHTMLjinitiator=basejini.htm
# System parameter: base HTML file for use with Sun's Java Plug-In
baseHTMLjpi=basejpi.htm
# System parameter: delimiter for parameters in the base HTML files
HTMLdelimiter=%
# System parameter: working directory for Forms runtime processes
# WorkingDirectory defaults to <oracle_home>/forms if unset.
workingDirectory=
# System parameter: file setting environment variables for the Forms runtime processes
envFile=default.env

# Forms runtime argument: whether to escape certain special characters
# in values extracted from the URL for other runtime arguments
escapeparams=true
# Forms runtime argument: which form module to run
form=test.fmx
# Forms runtime argument: database connection details
userid=
# Forms runtime argument: whether to run in debug mode
debug=no
# Forms runtime argument: host for debugging
host=
# Forms runtime argument: port for debugging
port=
# Other Forms runtime arguments: grouped together as one parameter.
# These settings support running and debugging a form from the Builder:
otherparams=buffer_records=%buffer% debug_messages=%debug_messages% array=%array% obr=%obr% query_only=%query_only% quiet=%quiet% render=%render% record=%record% tracegroup=%tracegroup% log=%log% term=%term%
# Sub argument for otherparams
buffer=no 
# Sub argument for otherparams
debug_messages=no
# Sub argument for otherparams
array=no
# Sub argument for otherparams
obr=no
# Sub argument for otherparams
query_only=no
# Sub argument for otherparams
quiet=yes
# Sub argument for otherparams
render=no
# Sub argument for otherparams
record=
# Sub argument for otherparams
tracegroup=
# Sub argument for otherparams
log=
# Sub argument for otherparams
term=

# HTML page title
pageTitle=Reyaz's Oracle Application Server Forms Services
# HTML attributes for the BODY tag
HTMLbodyAttrs=
# HTML to add before the form
HTMLbeforeForm=
# HTML to add after the form
HTMLafterForm=

# Forms applet parameter: URL path to Forms ListenerServlet
serverURL=/forms/lservlet
# Forms applet parameter
codebase=/forms/java
# Forms applet parameter
imageBase=DocumentBase
# Forms applet parameter
width=750
# Forms applet parameter
height=600
# Forms applet parameter
separateFrame=false
# Forms applet parameter
splashScreen=
# Forms applet parameter
background=
# Forms applet parameter
lookAndFeel=Oracle
# Forms applet parameter
colorScheme=teal
# Forms applet parameter
logo=
# Forms applet parameter
restrictedURLparams=HTMLbodyAttrs,HTMLbeforeForm,pageTitle,HTMLafterForm,log,allow_debug,allowNewConnections
# Forms applet parameter
formsMessageListener=
# Forms applet parameter
recordFileName=
# Forms applet parameter
serverApp=default
# Forms applet archive setting for JInitiator
archive_jini=frmall_jinit.jar
# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
archive=frmall.jar
# Number of times client should retry if a network failure occurs.  You should
# only change this after reading the documentation.
networkRetries=0

# Page displayed to Netscape users to allow them to download Oracle JInitiator.
# Oracle JInitiator is used with Windows clients.
# If you create your own page, you should set this parameter to point to it.
jinit_download_page=/forms/jinitiator/us/jinit_download.htm
# Parameter related to the version of JInitiator
jinit_classid=clsid:CAFECAFE-0013-0001-0022-ABCDEFABCDEF
# Parameter related to the version of JInitiator
jinit_exename=jinit.exe#Version=1,3,1,22
# Parameter related to the version of JInitiator
jinit_mimetype=application/x-jinit-applet;version=1.3.1.22

# Page displayed to users to allow them to download Sun's Java Plugin.
# Sun's Java Plugin is typically used for non-Windows clients.
# (NOTE: you should check this page and possibly change the settings)
jpi_download_page=[url]http://java.sun.com/products/archive/j2se/1.4.2_06/index.html[/url]
# Parameter related to the version of the Java Plugin
jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin
jpi_codebase=[url]http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06[/url]
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06
# EM config parameter
# Set this to "1" to enable Enterprise Manager to track Forms processes
em_mode=0

# Single Sign-On OID configuration parameter
oid_formsid=%OID_FORMSID%
# Single Sign-On OID configuration parameter
oracle_home=F:\DevS10g
# Single Sign-On OID configuration parameter
formsid_group_dn=%GROUP_DN%
# Single Sign-On OID configuration parameter: indicates whether we allow
# dynamic resource creation if the resource is not yet created in the OID.
ssoDynamicResourceCreate=true
# Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false
ssoErrorUrl=
# Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.
ssoCancelUrl=
# Single Sign-On parameter: indicates whether the url is protected in which
# case mod_osso will be given control for authentication or continue in
# the FormsServlet if not. It is false by default. Set it to true in an
# application-specific section to enable Single Sign-On for that application.
ssoMode=false
# The parameter allow_debug determines whether debugging is permitted.
# Administrators should set allow_debug to "true" if servlet
# debugging is required, or to provide access to the Forms Trace Xlate utility. 
# Otherwise these activities will not be allowed (for security reasons).
allow_debug=false
# Parameter which determines whether new Forms sessions are allowed. 
# This is also read by the Forms EM Overview page to show the 
# current Forms status.
allowNewConnections=true

# EndUserMonitoring 

# EndUserMonitoringEnabled parameter
# Indicates whether EUM/Chronos integration is enabled
EndUserMonitoringEnabled=

# EndUserMonitoringURL 
# indicates where to record EUM/Chronos data
EndUserMonitoringURL=

# Example Named Configuration Section
# Example 1: configuration to run forms in a separate browser window with
# "generic" look and feel (include "config=sepwin" in the URL)
# You may define your own specific, named configurations (sets of parameters)
# by adding special sections as illustrated in the following examples.
# Note that you need only specify the parameters you want to change.  The
# default values (defined above) will be used for all other parameters.
# Use of a specific configuration can be requested by including the text
# "config=<your_config_name>" in the query string of the URL used to run
# a form.  For example, to use the sepwin configuration, your could issue
# a URL like "[url]http://myhost.mydomain.com/forms/frmservlet?config=sepwin[/url]".
[sepwin]
separateFrame=True
lookandfeel=Generic

# Example Named Configuration Section
# Example 2: configuration forcing use of the Java Plugin in all cases (even if 
# the client browser is on Windows)
[jpi]
baseHTMLJInitiator=basejpi.htm

# Example Named Configuration Section
# Example 3: configuration running the Forms ListenerServlet in debug mode
# (debug messages will be written to the servlet engine's log file). 
[debug]
serverURL=/forms/lservlet/debug

# Sample configuration for deploying WebUtil. Note that WebUtil is shipped with
# DS but not AS and is also available for download from OTN.
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
archive=frmall.jar
lookAndFeel=oracle

New formsweb.cfg file as per your instructions:
[default]

baseHTML=F:\DevS10g\forms\server\webutilbase.htm,
baseHTML=F:\DevS10g\forms\server\base.htm
baseHTMLjinitiator=F:\DevS10g\forms\server\webutiljini.htm
baseHTMLjinitiator=F:\DevS10g\forms\server\basejini.htm
baseHTMLjpi=F:\DevS10g\forms\server\webutiljpi.htm
baseHTMLjpi=F:\DevS10g\forms\server\basejpi.htm

HTMLdelimiter=%

workingDirectory=

envFile=default.env

escapeparams=true

IE=JInitiator

form=test.fmx

userid=

otherparams=buffer_records=%buffer% debug_messages=%debug_messages% array=%array% obr=%obr% query_only=%query_only% quiet=%quiet% render=%render% record=%record% tracegroup=%tracegroup% log=%log% term=%term%
debug=no
host=
port=
buffer=no 
debug_messages=no
array=no
obr=no
query_only=no
quiet=yes
render=no
record=
tracegroup=
log=
term=

pageTitle=Reyaz's Oracle Application Server Forms Services
HTMLbodyAttrs=
HTMLbeforeForm=
HTMLafterForm=

serverURL=/forms/lservlet
codebase=/forms/java
imageBase=DocumentBase
width=850
height=700
separateFrame=false
splashScreen=
background=
lookAndFeel=Oracle
colorScheme=teal
logo=
restrictedURLparams=HTMLbodyAttrs,HTMLbeforeForm,pageTitle,HTMLafterForm,log,allow_debug,allowNewConnections
formsMessageListener=
recordFileName=
serverApp=default

archive_jini=frmall_jinit.jar
archive=frmall.jar

networkRetries=0

jinit_download_page=/forms/jinitiator/us/jinit_download.htm

jinit_classid=clsid:CAFECAFE-0013-0001-0022-ABCDEFABCDEF
jinit_exename=jinit.exe#Version=1,3,1,22
jinit_mimetype=application/x-jinit-applet;version=1.3.1.22

jpi_download_page=[url]http://java.sun.com/products/archive/j2se/1.4.2_06/index.html[/url]
jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA
jpi_codebase=[url]http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06[/url]
jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06

em_mode=0

oid_formsid=%OID_FORMSID%
oracle_home=F:\DevS10g
formsid_group_dn=%GROUP_DN%
ssoDynamicResourceCreate=true
ssoErrorUrl=
ssoCancelUrl=
ssoMode=false
allow_debug=false
allowNewConnections=true
EndUserMonitoringEnabled=
EndUserMonitoringURL=

[webutil]
WebUtilArchive=/forms/java/frmwebutil.jar,/forms/java/jacob.jar,/forms/webutil/jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384

baseHTMLjinitiator=F:\DevS10g\forms\server\webutiljini.htm
baseHTMLjinitiator=F:\DevS10g\forms\server\basejini.htm

baseHTMLjpi=F:\DevS10g\forms\server\webutiljpi.htm
baseHTMLjpi=F:\DevS10g\forms\server\basejpi.htm

archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
archive=frmall.jar
lookAndFeel=oracle
width=100%
height=100%

[sepwin]
separateFrame=True
lookandfeel=Generic

[jpi]
baseHTMLJInitiator=basejpi.htm
baseHTMLie=basejpi.htm

[debug]
serverURL=/forms/lservlet/debug

[Updated on: Wed, 05 July 2006 01:38] by Moderator

Report message to a moderator

Re: push button [message #182017 is a reply to message #180729] Wed, 12 July 2006 10:33 Go to previous messageGo to next message
wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia
Member

Hi David,
I am still facing the same problem.
waiting for your valuable reply
Re: push button [message #182272 is a reply to message #182017] Fri, 14 July 2006 01:34 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Reyaz,

Please review the formsweb.cfg I supplied previously.

Please remove the '[default]' section heading. It is a dangerous name.

baseHTML=F:\DevS10g\forms\server\webutilbase.htm,
baseHTML=F:\DevS10g\forms\server\base.htm
baseHTMLjinitiator=F:\DevS10g\forms\server\webutiljini.htm
baseHTMLjinitiator=F:\DevS10g\forms\server\basejini.htm
baseHTMLjpi=F:\DevS10g\forms\server\webutiljpi.htm
baseHTMLjpi=F:\DevS10g\forms\server\basejpi.htm

This is wrong. You should only have each entry exist one time, and they should never have a trailing comma. Just use the webutil entries.

I suggest that you base your formsweb.cfg very closely on the one that I posted previously.

Review your file and make sure that you don't have any [url] and [/url] entries.

David
Previous Topic: On-Screen-Validation
Next Topic: Tab within Tab
Goto Forum:
  


Current Time: Thu Apr 18 03:00:33 CDT 2024