General information
Category:
Coding, syntax & commands
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only