Information générale
Titre:
Unable to execute procedure in oracle database
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement