ahhh,
no wonder it was not working. I just tested it and it worked.
Thanks Tim.

>Hi...
>
>To run his code in toad you need to use the "procedure editor" and not the sql window if you do it there you need to select higlight each of the two commands seperatly then run them (without the /).
>
>To execute the code you can run
>
>select FNext() FROM Dual;
>
>BR
>Tim
>
>
>
>>
>>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
>>
>>
>>>Yep. When I run the code I provided to you in SQLPlus, it works perfectly.
>>>
>>>>My apologies,
>>>>after I sent the message I realized I did not say when it was giving me the error.
>>>>I pasted the code you highlighted into TOAD, (a product from Quest Software)
>>>>when I executed it, it came out with "ORA-00911: invalid character"
>>>>You think I should try from SQL Plus?