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

colin_lyse wrote:

> Do you have a beter solution? do you recommend putting the code together on
> the client side and sending it to oracle? is that a better solution?

My posting was satire Colin.

However, if you do want a better solution than ASP - it is called HTMLDB. ;-) Seriously though, the biggest problem in building dynamic SQL is creating non-sharable statements. Especially when literals are added directly to the statement and not via bind variables.

I also draw a clear line between what the presentation layer should and what the database should do. Simple example, I will not create two different SQLs just because one web user wants to see COL1 and COL2 and the other web user COL1 and COL4 from the same query/report. Which columns to render (and in what sequence), is the presentation layers problem. Catering for that on the database again leads to non-sharable SQL and simply makes the whole SQL interface more complex to maintain.

--
Billy