Forms45 bug: Null function & local variable

Hi, everyone,

I have encountered a nasty bug in Forms 4.5. It occurs in both versions I have available: 4.5.6.0.7 and 4.5.6.5.5.

When you create a function that can return text or null, and you try to set a PL/SQL local variable using that function, the null setting will not work. After calling the function, the local variable contains its original value from before the function was called.

However, if you use the same function to set an item on the canvas, the item is always set to null.

This does not occur in SQL Plus, so the problem is possibly due to the fact that Forms 4.5 still uses PL/SQL version 1.

Here is some code to try and see for yourself:

Declare
  V varchar2(10);
  Function NulVal return varchar2 is begin     Return NULL;
  End;
Begin
  :b1.item1 := 'AAA'; :b1.item1 := NulVal;   V := 'BBB'; V := NulVal; :b1.item2 := V; -- item1 will show null, and item2 will contain 'BBB' -- End;

I wonder if Oracle knows about this one? If anyone knows, please let me know.

Regards,
Steve Cosner Received on Fri Aug 30 1996 - 00:00:00 CEST