I have my OV7670 VGA camera and Pmod working now, if not with very high image quality.

The problem I was having before with the SCCB i2c interface for configuring the camera was that I was not giving the device an x_clock signal. I thought that was only needed for camera capture but it is needed for configuration too.

You can buy the camera modules for about 2 f on ebay and you can get the PCB for the Pmod from OSH Park.

I have currently capturing the video image to dual-ported BRAM. There is only enough BRAM on the BlackIce for a 160x 120 image with two bits per colour.

So the self-portrait is not that accurate.

I will try use SRAM to capture the image but as the SRAM is not dual ported, I won't be able to do continuous capture.

No, it is this one - https://oshpark.com/shared_projects/HAZ1ZB7w.. The camera module has 9x2 pins and the PCB 8x2 but the reset and power down pins don't seem to be important. The first Pmod I made, I soldered the module to the PCB and bent the reset and power down pins at 90 degrees so I could use them if necessary.

I then made another Pmod with a female header on the PCB. I used a 9x2 female header with two pins removed.

There are other OV modules with higher resolution but it is hard enough getting the VGA 7670 working. The SRAM will just about hold one 640x480 image with 12 bits per pixel.

Hi....the resolution is 640 x 480 so it is not going to have a very nice looking image. I have not heard of anyone using this camera on a Pi, so I suspect it would take some work to achieve. If you just want small and cheap, you can get USB webcams with that resolution, for a similar price or even less, which might work on the Pi without any software or hardware effort.