how come I cannot insert into table inside function?
726277Oct 7 2009 — edited Oct 7 2009if I have a simple function that takes same data with SELECT ... INTO .... and then that information I need to insert back to the same table, but the error message says I cannot insert, update, delete on a table I am working on, but my understanding is that SELECT ... INTO will actually copy data from a select query to those variables I use in my SQL Function. So why, after finishing Select I cannot update into the table that my SELECT stopped already working on.