my $prepStatement = <<TO_END_SQL_STATEMENT;
insert into ORACLE_TABLE 
( LINK_ID, POI_ID, ......  TEST_ID ) 
values 
( '$LINK_ID', $POI_ID, ..... , $TEST_ID' )  
TO_END_SQL_STATEMENT