Moritz Klein wrote:
> Hi to everybody,
>
> I am new to this newsgroup so please don't hesitated to tell me about
> errors I do. I am german can speak English rather well but I am not
> that good in written English so please be kind. ;-)
>
> I am about to get a database working in which will be stored
> information about the shared folders and files within our local
> subnet. Do keep the query rate as low as possible we use a script
> which first collects every new folder and puts them all together in
> one update-query. Afterwards the same script should update the
> files-table with references to the folders. I wrote a sequence and a
> trigger so the auto increment is working. Now I want the trigger to
> return the ID and the Name of the currently inserted directory to get
> this information into an array and use it to reference the files. The
> problem is that Oracle keeps telling me I can't use return within
> triggers. I am stuck does anybody knows what to do?
>
Sorry forgot Database Version. I am using 9i.
Received on Wed Dec 18 2002 - 03:33:45 CST
