Re: Functions that Insert data and return value

When you run de function from the DOS prompt with SQL-Plus, it does not give that message. But maybe that is not what you want.

Erik

>I created a function that creates a record in a table and returns the id
>of this record. Unfortunately I keep getting the following:
>
>'Function GET_EQUIP_ID does not guarantee not to update database'.
>
>I searched and found out that to use a function in SQL the function
>could not have any side effects. Is there any way around this? It
>seemed like a very simple problem at first...
Received on Wed Dec 08 1999 - 02:55:00 CST