Re: Why would concatenating a variable to a variable give an error in pl/sql?

colin_lyse wrote:
>
> we are doing the following (code not complet took parts out for brevity)
<snipped>

Back in the 80s' we coded something like CALL GETEMPRECORD USING ID RETURN EMP_REC. And then we had to code the GETEMPRECORD. And cater for every single criteria that could be passed. And deal with different sort orders and what not. And winded up with 50 or more versions of GETEMPRECORD.

How we wished for a method that allowed you to dynamically just say what you want.

Then SQL came along. It was kewl. We chucked away the 50 versions of GETEMPRECORD and use SQL instead. A lot more flexible. A lot more powerful. A lot more easier to read and maintain

Fast forward to the 21st century.

Now we have developers that look at SQL and goes "Duh... this is friggen too complex!" And the proceed to write 50 versions of getPCBDetailResults using dynamic and non-shareable and bind-less SQL... Progress is great, huh?

--
Billy