Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Karachi, Pakistan
    Posts
    45

    Unanswered: FORMULA-CALCULATION trigger raised unhandled exception

    Hi Peoples

    I use Formula through item property in 9iDs. and when i use nvl in that
    formula Application Server generate that run time error, if anybody idea
    about that , please answer me immediately,

    Thanx

    Noor Ali

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Re: FORMULA-CALCULATION trigger raised unhandled exception

    Originally posted by nooralig
    Hi Peoples

    I use Formula through item property in 9iDs. and when i use nvl in that
    formula Application Server generate that run time error, if anybody idea
    about that , please answer me immediately,

    Thanx

    Noor Ali
    What is the error? Where is the code fragment? You need to provide more info otherwise it is YOYO (you are on your own) time.

  3. #3
    Join Date
    Dec 2003
    Location
    Karachi, Pakistan
    Posts
    45

    Re: FORMULA-CALCULATION trigger raised unhandled exception

    Hi

    I though its enough to say "using nvl in formula calculation", anyhow
    i use that code in forumla calculation
    "
    (nvl(rovisional_bills,0) / (
    nvl(rovisional_bills,0)+nvl(:NCCM0,0)+nvl(:NCCM0128,0) +nvl(:NCCM2931,0)+nvl(:NCCM3234,0)+nvl(:NCCM3537,0 )+nvl(:NCCM3839,0)+nvl(:NCCM4042,0)+nvl(:NCCM4345, 0)+nvl(:NCCM4648,0)+nvl(:NCCM4951,0)+nvl(:NCCM5254 ,0)+nvl(:NCCM5556,0)+nvl(:NCCM5770,0)+nvl(:NCCM711 41,0)+nvl(:NCCM142282,0)+nvl(:NCCM283423,0)+nvl(:N CCM424ABV,0)
    "

    so problem still occur, and one interesting thing for me is that, if i remove NVL from last column i.e. :NCCM424ABV, error is remove.
    its not understandable for me, Please Help me if u understand my problem.

    Thanx

    Noor Ali

  4. #4
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Going by your variable name I am going to guess that it is a string. Try
    nvl(:NCCM424ABV,'0').

    Still would like to see the error number/mesage if this suggestion does not work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •