Forum Stats

  • 3,771,041 Users
  • 2,253,212 Discussions
  • 7,875,714 Comments

Discussions

WEBUTIL with oracle forms 12c

User_HM5WZ
User_HM5WZ Member Posts: 9 Green Ribbon

hello there is a problem with webutil after upgrading to oracle 12c ,FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508 webutil


any suggestion ? thx

«1

Answers

  • SFrix
    SFrix Member Posts: 129 Bronze Badge

    Hello @User_HM5WZ

    Webutil pll source file need to be taken from Forms12 delivery. If you try to compile the pll you used in Forms11 it does not work.

    PLX need to be rebuilt with the correct source file.

  • User_HM5WZ
    User_HM5WZ Member Posts: 9 Green Ribbon

    thanks SFrix,after I replaced the old webutil pll with the one taken from Forms12 delivery ,I got additional error when no data found error.

    we were using webutil_lib before upgrading.

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,910 Employee
    edited Oct 15, 2021 3:13PM

    @User_HM5WZ Something else to be aware of is that the "create_webutil.sql" script provided with v12.2 should also be executed in order to replace the old. It contains changes that will improve file transfer rates by as much as 30%. Refer to the Forms New Features Guide for an overview of these and many more changes introduced in the latest version Forms.

    https://www.oracle.com/application-development/technologies/forms/forms.html#panel2


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM

  • User_HM5WZ
    User_HM5WZ Member Posts: 9 Green Ribbon

    thx Michael,

    it is installed ,after receiving no data found error,I am getting the following error


  • SFrix
    SFrix Member Posts: 129 Bronze Badge

    @user_HM5WZ, this is in your code. Check the image you load or manipulate.

  • User_HM5WZ
    User_HM5WZ Member Posts: 9 Green Ribbon

    yes ,indeed it is in our code.

    in general:

    attach new webutil.pll and

    execute the create_webutil.sql

    is sufficient to get it work ? or there is other steps?

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,910 Employee

    As mentioned by @SFrix , the error you are seeing is your own. So you need to troubleshoot your own error. It is not a "Forms" generated error.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM

  • User_HM5WZ
    User_HM5WZ Member Posts: 9 Green Ribbon

    yes thanks, the previous error is solved ,but I still have the problem ,any suggestion are welcome.

    in my java console I have the following :

    basic: JNLP2ClassLoader.findClass: oracle.forms.handler.AlertDialog: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.forms.handler.CommonDialog: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.alert.AlertPane: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.alert.BaseAlertPane: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.alert.BaseAlertPane$Access: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.multiLineLabel.MultiLineLabel: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.alert.BaseAlertPane$PreferredAspectLabel: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.event.HelpEvent: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.plaf.AlertUI: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.event.HelpListener: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.laf.generic.GenericAlertUI: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.laf.generic.GenericAlertUI$1: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.alert.AlertRowLayout: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.multiLineLabel.MultiLineLabel$Access: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.multiLineLabel.LineInfo: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.multiLineLabel.LabelGeometry: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.forms.handler.DialogThread: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.alert.resource.AlertBundle: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.alert.resource.AlertBundle_en: try again ..

    basic: JNLP2ClassLoader.findClass: oracle.ewt.alert.resource.AlertBundle_en: try again ..


    and in the server tracing :



    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    Error Message: FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508."><EventID> 192476</EventID>

    Error Message: FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508.</Msg> </Details>

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=In Position=3 DataType=STRING Value=FRM-01403 : ORA-01403: no data found

    <ALERT.START Name="QMS$INFORMATION.FRM-01403 : ORA-01403: no data found

    <FormName> S716_FRM_PIM_CRUD(45)</FormName> <Name> QMS$INFORMATION</Name> <Message> FRM-01403 : ORA-01403: no data found

    Error Message: FRM-40735: WHEN-TIMER-EXPIRED trigger raised unhandled exception ORA-06508."><EventID> 192885</EventID>

    Error Message: FRM-40735: WHEN-TIMER-EXPIRED trigger raised unhandled exception ORA-06508.</Msg> </Details>

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=ORA-01403: no data found

    <BuiltinArg>Type=In Position=3 DataType=STRING Value=FRM-01403 : ORA-01403: no data found

    <ALERT.START Name="QMS$INFORMATION.FRM-01403 : ORA-01403: no data found

    <FormName> S716_FRM_PIM_CRUD(45)</FormName> <Name> QMS$INFORMATION</Name> <Message> FRM-01403 : ORA-01403: no data found

    Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508."><EventID> 193213</EventID>

    Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</Msg> </Details>

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</BuiltinArg>

    <BuiltinArg>Type=In Position=3 DataType=STRING Value=FRM-40735 : WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</BuiltinArg>

    <ALERT.START Name="QMS$INFORMATION.FRM-40735 : WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508."><EventID> 193494</EventID>

    <FormName> S716_FRM_PIM_CRUD(45)</FormName> <Name> QMS$INFORMATION</Name> <Message> FRM-40735 : WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</Message> </Details>

    Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508."><EventID> 193559</EventID>

    Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</Msg> </Details>

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</BuiltinArg>

    <BuiltinArg>Type=In Position=3 DataType=STRING Value=FRM-40735 : WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</BuiltinArg>

    <ALERT.START Name="QMS$INFORMATION.FRM-40735 : WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508."><EventID> 193840</EventID>

    <FormName> S716_FRM_PIM_CRUD(45)</FormName> <Name> QMS$INFORMATION</Name> <Message> FRM-40735 : WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</Message> </Details>

    Error Message: FRM-40735: KEY-EXIT trigger raised unhandled exception ORA-06508."><EventID> 193887</EventID>

    Error Message: FRM-40735: KEY-EXIT trigger raised unhandled exception ORA-06508.</Msg> </Details>

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=KEY-EXIT trigger raised unhandled exception ORA-06508.</BuiltinArg>

    <BuiltinArg>Type=In Position=3 DataType=STRING Value=FRM-40735 : KEY-EXIT trigger raised unhandled exception ORA-06508.</BuiltinArg>

    Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508."><EventID> 194206</EventID>

    Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</Msg> </Details>

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</BuiltinArg>

    <BuiltinArg>Type=In Position=3 DataType=STRING Value=FRM-40735 : WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</BuiltinArg>

    Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508."><EventID> 194527</EventID>

    Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</Msg> </Details>

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</BuiltinArg>

    <BuiltinArg>Type=In Position=3 DataType=STRING Value=FRM-40735 : WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06508.</BuiltinArg>

    Error Message: FRM-40735: KEY-EXIT trigger raised unhandled exception ORA-06508."><EventID> 194840</EventID>

    Error Message: FRM-40735: KEY-EXIT trigger raised unhandled exception ORA-06508.</Msg> </Details>

    <BuiltinArg>Type=Out Position=1 DataType=STRING Value=KEY-EXIT trigger raised unhandled exception ORA-06508.</BuiltinArg>

    <BuiltinArg>Type=In Position=3 DataType=STRING Value=FRM-40735 : KEY-EXIT trigger raised unhandled exception ORA-06508.</BuiltinArg

  • User_HM5WZ
    User_HM5WZ Member Posts: 9 Green Ribbon

    hello All ,

    now the only issue that able to upload files greater than 20KB with WEBUTIL with this error

    any suggestion ?

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,910 Employee

    The error appears to be in your own code.

    Given the problems you are having, it might be easiest to create a simple test case and not use your real applications. Create a new form that includes WebUtil and no other complex code. Simply add a button with the code needed to upload a file using WebUtil. Again, do not add any ON-ERROR code or other code that is not necessary to perform this simple function. Assuming it works, you can assume the problem is in your app code.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM