Re: COPY and NAME_IN error Forms 4.5

Hi,

[Quoted] The Copy statement syntax is COPY(source, destination), as opposed to assignment, which is destination := source. Reverse your Copy parameters and it should work.

slniemann_at_my-dejanews.com wrote in article <6vgi0m$l0q$1_at_nnrp1.dejanews.com>...
> I keep getting a form runtime error stating that my COPY() function's
second
> value cannot be NULL
>
> the PL/SQL is generic, passing in a block name, and attaching the passed
in
> block name to an item name variable (ie var1 VARCHAR2(50) := blk ||
'.item2';)
> there are numerous variables, one for each item in the block. I need to
swap
> label values between two items. The traditional 3-way switch is used:
> PROCEDURE CHANGE(blk IN VARCHAR2) IS
> var1 VARCHAR2(50) := blk || '.item2';
> temp_var VARCHAR2(50);
>
> BEGIN
> /*
> temp_var := item1;
> item1 := item2;
> item2 := temp_var;
> */
> Copy(temp_var, NAME_IN(var1)); -- <-- this is where the NULL error is
set
> Copy(NAME_IN(var1), NAME_IN(var2)); Copy(NAME_IN(var2), temp_var);
> END;
>
> To make this generic, I am using Copy(temp_var, NAME_IN(var1))
> Unfortunately, the var1 keeps coming up null, but in debugger, I check
the
> value within, and there is a value in [the item inside].
>
Received on Thu Oct 08 1998 - 06:28:44 CEST