hi there,

i am unable to execute stored procedure in oracle database. To access the data from oracle application (11i) views we need to execute one stored procedure

fnd_clent_info.set_org_context(OrgID)

after executing this procedure, one can acces data from views. Actually this function sets organization ID.

problem which i am facing is using sqlexec() function of VFP i can access data from oracle application tables. but when i execute above mentioned procedure using

=sqlexec(gconn,"{call fnd_clent_info.set_org_context(OrgID)}"

after this when i try to access data from any view using statement

=sqlexec(gconn,"select * from "view name",mycursor)

it returns nothing.


my question is why this procedure is not getting executed through foxpro. same procedure works when i use TOAD free for oracle. Or if i execute same code in visual basic using ADO.

pleaes help.


regards

devrishi