reference cursor is better/effective, as it is used as a pointer in the cursor.

Is this server dedicated to Oracle or shared to another service?(Just asking)