you need to commit your insert.
so add a COMMIT statment?
I turned on oracle auto commit thinking that might help... but that only seems to apply to the individual SQL Plus session and not the DB as a whole.
btw. I do have a sql:execute statement in place.. not sure why it didnt paste over.
thanks again for the help,