changing : SELECT q'[package.Procedure('val(x)');]' FROM dual to : SELECT q'[package.Procedure('val(x) ');]' FROM dual