I am loading some xml data into a column (BLOB Data type) using stored procedure. It is asking for substitution variable. In SQL Developer Client , I generally give SET DEFINE OFF to over come this. Since Set Define off is a client command , how can i achieve the same functionality inside a stored procedure.i.e., when inserting a Clob which have '&' symbol , the procedure should not ask for substitution variable.