Can we call both dml and dql statement in a function in Oracle? [closed]
I have a function with DML(insert ) statement.I am calling this function from other main function which has return type as table(using bulk collect). Though after calling main function,data get inserted into table ,but no output comes of select query of table type. Please,suggest any technique to do it.