Pro*C & PL SQL

Hi

I just want to know how can i use PRO*C,PL SQL in datawarehousing projects(datastage). What is the purpose of PRO*C.

Thanks in advance
barbie