global variables pros/cons (1 Viewer)

[Funkyaccess]

Can someone please help me with trying to understand the pros and cons of using global variables. I know they can be used anywhere within the db but I assume that they consume memory.

 

[georgedwilkinson]

This has been discussed at length here (and lots of other places).