Hi, there is not enough information. What have you tried, and what is the problem that you are encountering?

I am developing a vendor registration portal using Joget. The objective is to automatically update an Oracle table upon approval of a vendor. Subsequently, I need to retrieve the vendor_id and party_id from the Oracle table and update the corresponding fields in the Joget table or workflow variable . for data posting in oracle we use MS SQL stored procedure in which we provide vendor name,org_id,supplier type,supplier url,invoice match opt then the stored procedure give in responds Vendor id and party id which i unable to get in joget table ,

For inserting data in oracle i am using MS SQL stored procedure. I have used database update tool with custom datasource option to run stored procedure i want to store return result either in joget table or work flow variables.

Note: joget database in on MY SQL and oracle data base is on MS SQL .

I am confused, is Oracle the database or is it MS SQL? In any case, you can use BeanShell to store the result in a form table (Store Form Field Data to Multiple Tables) or workflow variable (Setting Workflow Variable Value in Process Tool Bean Shell).