Subject Re: External procedures: implementation proposal.
Author Roman Rokytskyy
> > So, the question is whether we define a new module for "C"
> > language that would resolve the external name
> > "ib_util:some_procedure" on Windows into "ib_util.dll" and
> > "some_procedure" entry point?
>
> Yes, I think so.

Ok, then if no other comments come, let's assume that's the solution.

> > Then don't let it crash. I do not think that C++ is not capable of
> > handling something like "NullPointerException" (in that case it
> > would be access violation) generated in the SP/UDF.
>
> If this AV comes into the engine, it aborts. There's no other
> option.

Cannot you wrap all calls into try/catch? AV in external module is not
something that server should really care about.

> I'd like to hear Paul's explanation of this feature. In Oracle, a
> cursor reference (may be treated as a result set) could be an OUT
> param. But the engine doesn't support anything like this yet.

I have forwarded him this post, hopefully he joins the discussion.

Roman