Mark,
I will do that. In fact I was checking some info there yesterday but since I don't have search option with my account I did not see much.
I'll love to see some samples when you have a chance.
I hope you're enjoying the conference

Thanks for all your help.

>Go to the UT Oracle forum and do a search on my UT member ID [12473]. YOu should find some examples of stored procs that may help. Functions can only return 1 value, but you can pass parameters from VFP to SPs by reference and have the SP stuff values into them. This is how you would get multiple values back from an Oracle SP. When I get time after WhilFest, I will post some stuff here if you still need help.
>
>>Absolutely,
>>and also found out I cannot created with my login name. It says I don’t have enough privileges. Even though, I called the DBA before sending the message and told me I have "resources" and I can do everything.
>>But the code works, when I tied it with the developers account. The only thing is that from TOAD, even with the developers acc keeps on giving me the same error.
>>
>>Now let me ask you,
>>Let say I have a function that returns 2 values, what is the syntax to call it?
>>
>>Thanks for all your help Mark