How can I use system variable in mysql

Question

How can I use system(operating system) variables like JAVA_HOME In my own mysql stored procedure.

Answer 1

Guess you may need to use an external library such as UDF Repository for MySQL to do this. A reference to the library can be found here. There should be a sys_get() function call that may serve the purpose.