Re: Dynamic Block program unit?

On 21 Jan 2003 11:44:18 -0800, hap_at_mikomi.org (Adam Hapworth) wrote:

>Hello All,
> I have a form that goes against our database and looks at 4 tables
>...
>procedure c(block_name in varchar2)
>is
>begin
>block_name.item1 := 'foo';
>end;
>
>How would I go about doing something of this sort.
>
>I know this may sound like a silly design but it is all I have to work
>with :(

Copy and name_in functions are your friends

-- 
Luc Bosman
DEV/2000 Software Engineer
Database & Network Administrator
l.bosman_at_iile.be
 ---------------------------------------------------- 
|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ----------------------------------------------------