I have a table with an existing paramatised view against it.

I need to add a record into the table and want to do it via the view (in case app is upsized)

As such I need to start off with the view empty ready for me to do the single insert into it I need.

At present I just change the view parameters to something that I know will not return any data.

ie clMyParam='zxx##xxz' or something.

Does anyone know of a better way because this technique is not very elegant.