COPY and NAME_IN error Forms 4.5
Date: Wed, 07 Oct 1998 20:13:10 GMT
Message-ID: <6vgi0m$l0q$1_at_nnrp1.dejanews.com>
[Quoted] I keep getting a form runtime error stating that my COPY() function's second [Quoted] value cannot be NULL
the PL/SQL is generic, passing in a block name, and attaching the passed in
[Quoted] block name to an item name variable (ie var1 VARCHAR2(50) := blk || '.item2';)
[Quoted] there are numerous variables, one for each item in the block. I need to swap
[Quoted] 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 [Quoted] 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 [Quoted] value within, and there is a value in [the item inside].
What am I doing wrong? This has to be generic, or extremely long, because I have five identical (differently named) windows/canvases/blocks in this application with a potential for more.
Any suggestions are more than welcome!!!
BTW Forms version 4.5.6.5.5
PL/SQL version 2.1.4
Oracle 7.3.2.3
Thanks!
S Niemann
[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Oct 07 1998 - 22:13:10 CEST