oracle function to join with QV

[engr_farhanqadr]

Folks,

I have a oracle function abc(code) which shows a count of manpower of a specific manager I have codes of manager in list box.

how can I pass and join this code in function and join them.

Thanks,

Farhan.

[rbecher]

Hi,

you can use your Oracle function only in the Oracle SQL Select statement. But maybe you can adapt the code of this function to build a mapping table in QlikView.

- Ralf

[Anonymous]

you must call your oracle function in the script.

connect to Oracle database.

sql select code, abc(code) from "table contening yours managers";