Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: functions vs procedures
> Is there a way to insert records in a function?
Yes. Functions can do the same operations as a procedure. They just have a return value.
> I want to use functions because i can fetch the error messages then.
Depending on what you are doing, you may want to look into exceptions. Your function (or procedure) can raise an exception, which the caller can trap and get the message.
> How can I combine functions and procedures????
You can also have the function call the procedure, if it helps.
>
> Thank you already,
>
> Julian Kooiker
>
>
Received on Wed Feb 20 2002 - 17:47:18 CST