Function and Insertstatement

From: Dirk Joosen <d.joosen_at_REMOVETHIS.planetinternet.nl>
Date: Thu, 18 Nov 1999 11:23:34 +0100
Message-ID: <3833D3A6.E05298C3@REMOVETHIS.planetinternet.nl>

Hello,

Can someone tell me if it is possible to use a INSERT statement in a Function. When I use the INSERT statement I become next failure when I run the function.
ORA-06571: Function GETCLIENTID does not guarantee not to update database.

The reason that I use a Function is that I want to return a ID which I use.
I know that I also can declare a procedure whith an IN OUT argument but I thought that a Function was easyer to use.

Thanks and regards Dirk Received on Thu Nov 18 1999 - 04:23:34 CST