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


>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?