Thanks for the info but my problem is now I am passing the values from the WEB. Means the user is entering the values on the browser and I am capturing the values in to these two variables p_new_proj_id and P_upd_proj_id and I am passing the variables directly to sqlrun stream which is calling my procedure and it is supposed to take the values but some how its not taking the variables which I am passing from the web browser.

As per ur answer I have to create the values on my procedure but its not possible because user enters the values and those values has to go directly to the variables which I declared on the procedure like the following update statement.

UPDATE rem_acquisition_screening
SET proj_id = '$P_new_proj_id'
WHERE proj_id = '$p_upd_proj_id'

Thanks