Hello all. I am not too good at writing pl/sql and have a bunch of books in front of me that are only useful for beating my head against.

I am trying to write a procedure that variables can be passed through it to a query that then selects into another table. So far no luck.

Can anyone post some kind of sample ddl for this. I know it can not be that difficult.