Your Location is: Home > Oracle

Can we call both dml and dql statement in a function in Oracle? [closed]

From: Macau View: 2579 Ruhi 

Question

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.

Best answer