Re: oracle connection

[Eliya]

You could put them in a hash. For example, pass the names to the routine (e.g. proc( [qw(foo bar)] )), and then say in the routine

    my $names = shift;
    ...
    
    @v{@$names} = $sth->fetchrow()

(The @v{...} is a hash slice, which means you can assign multiple entries in one go.)

You can then access the "variables" as $v{foo} and $v{bar}.

[Corion]

You can also directly ask DBI to return you a hash:

my $hash = $sth->fetchrow_hashref();

[Eliya]

Sure you can (presuming the query produces the desired column names).

I was mainly trying to answer the general case, i.e. the typical "beginner's" problem of wanting to dynamically create variables like

    $xxx = "$DBNAME,$USERNAME,$PROFILE";
    my ( '$xxx' ) = ( ... );