Yes, you will get confused if you confuse technologies. I said OC(one C)I, not OCC(two C's)I. These are not the same, and I don't recommend OCC(two C's)I.

If you download the Companion disk (10g) or Examples disk (11g), this includes OCI examples that you can try out and study. These are good for getting you started. Also have a good read of the Oracle OCI Programmer's Guide.