Hi Hrishy,

Thanks for your reply. basically the number of values which i am going to read from data.txt is unknown and hence i am reading all these values one by one in unix scirpt and framing them as one string as '123','234','345' etc.... and store it in a unix variable.

d = '123','234','345'

I had one idea that, if it is not possible by passing it as parameter then as an alternate way export this unix variable.

if there is any possibility that i can read this unix exported variable (enviroment variable) in oracle then i think it will resolve my issue.

ie., is there anyway that i can read unix environment variables in oracle?

or appreciate if you have any other ideas.


Thanks,
perot