Dynamic pivot

report error:
ORA-00904: "D"."SALESMAN": invalid identifier

xml pivot

JobANALYSTANALYST SCLERKMANAGERPRESIDENT
1011300
2000014
3010000
 00010
As described here by fac586 (Paul MacMillan)