Forum OpenACS Q&A: Re: Tricky query port (pg -> oracle)

Collapse
Posted by Don Baccus on
This is a general PL/SQL utility that's supposed to be implemented for any object type that wants to return a custom name rather than acs_object.name().

PL/SQL can't call Tcl and the overriding logic is in the generic object PL/SQL code.

Calling these isn't bad if you have a small number of rows being returned, it's only when you're processing lots of rows that they're a problem.  Though as I'm sure you know we're talking about denormalizing this data.