Using EXEC to execute Pro*C program

[Faiz]

Hi,
In order to search in a specific area, I need data from the oracle database. I am using the EXEC function to execute a Pro*C program which gets the data from oracle and then use it in the search script.
In the Pro*C program, I can either print the values and get it in EXEC or write it in a file and then read the file from within the search script.
Is there a better way to do it?
Regards,

[John]

In general you would have the program print the values and use $ret after the <exec>. Since you are searching I'm assuming that the amount of data is relatively small.

If you were getting a large amount of data that you wanted to process bit by bit you could write to a file and then use <readln> or <timport>.