Sybase vs Oracle SQL

I have to take a Syabse stored procedure and make it work on Oracle 8i.
The procedure basically creates a temporary table which it then inserts records into based on data selected from other tables.
It then manipulates the data and returns a resultset from a final select.
Just cutting and pasting the procedure doesn’t work, the Create table statement seems to be the problem.
Does anyone know of any sites with ‘GOOD’ examples of PL/SQL code, particularly with examples of tables data manipulation.
I am aware that this sort of procedure needs to use Dynamic SQL but I’m a real learner on all of this.
I don’t want to show the code here but if anyone can help me via email I can send them the procedure.