Forum OpenACS Development: Response to porting a db_dml transaction

Create a list with the key values in the correct order to match the postgresql function call - oracle won't care about ordering since you're using named variables here.

        # foo, bar, and baz match key names in info_pairs
        set ordered_keys [list foo bar baz]
        foreach i_key $ordered_keys {
                  append sql "$i_key => $info_pairs($i_key),"
                  set $i_key $info_pairs($i_key)
        }

Then in your postgresql .xql file reference the variables in the correct order for the mp3__new function.