biztalk adapter for mysql_Biztalk Oracle Adapter for Select Procedure

Hi,

I m working on biztalk 2006 r2 + oracle. i created one select oracle procedure (as below) which is inside package and also define inside package defination but when i try to generate receive schema, i m not able to see the procedure. Is their any diffrent way to write procedure?

Is anyone can give me the step by step process for same.

PROCEDURE sp_select_biztalk(OUT_refcursor OUT p_ref_appdetails)

IS

BEGIN

OPEN OUT_refcursor FOR

SELECT NAME,EMPNO, ADDRESS,PHONE,PROJECT

FROM TBLBIZTALK WHERE FLAG='Y';

EXCEPTION

WHEN OTHERS THEN

NULL;

END sp_select_biztalk;

i already created procedure (mentioned above) in pakage and in pakage defination.

I am not able to see select or get procedure in receive port configuration or nor at the time of generating metadata for same.

I am doing following steps.

1) Created oracle adapter receive port and location (configured receive location with oracle connection string and able to see oracle database in managing event property. But not able to see get or select procedures)

2) Created empty biztalk project.

3) Generated metadata for receive schema using configured receive location. (Right click on project --> Add generated items --> Generate metadata...through this wizard i m using configured receive location).

i am able to see insert, update procedures but unable to see get or select procedures. How do i do this?

Regards

Girish Fuluskar