Do not use the following execute statement. Just fetch that cursor in the stored procedure in order to read the data or get the result set from other applications by calling the stored procedure.

EXECUTE CSR1 USING LOC1; --Not required, as Allocate will open the cursor.