Something better is needed. This something is the Command object. The Command object is like the Connection object on steroids. It can perform many of the same features and more. The Command object requires four items.
Parameters requires five items to be created.
First, it requires the name of the field in the stored procedure. Second, it requires the type of field with the most common types being 200 for Varchar and 131 for Numbers. Fourth, it requires the maximum size of the field. Fifth, it requires the value of the field that is going into the stored procedure that is generally supplied by calling subroutine. Append pMessage oCmd.