ORA-01002: fetch out of sequence : Getting eror when connecting from ASP.net to the stored procedure

I am trying to execute a store procedure from ASP.NET. There is one SQL in the stored procedure that joins two table. One table is from a Oracle database and the other from MSSQL. The query by itsef executes independently in TOAD. Infact the procedure compiles and also runs in TOAD. But when I  invoke it from Visual studio I get the following error.

ORA-01002: fetch out of sequence
ORA-02063: preceding line from MESBODY

CREATE OR REPLACE PROCEDURE HGMC.missedbodyrptg(

OR REPLACE PROCEDURE HGMC.missedbodyrptg( dt1 IN char, idx IN char, p_rc OUT sys_refcursor OUT sys_refcursor )