You need to sign in to do that
Don't have an account?
sfdcraj
Calling a SQL stored procedure from apex code
Hi,
is is there anyway that I could call a SQL stored procedure from apex code.
i used db amp app to get all my Salesforce tables into SQL server to integrate with another database through stored procedure .
i want to call this stored procedure on click o a button on my visual force page.
can anyone please guide me???
regards,
pruthvi
is is there anyway that I could call a SQL stored procedure from apex code.
i used db amp app to get all my Salesforce tables into SQL server to integrate with another database through stored procedure .
i want to call this stored procedure on click o a button on my visual force page.
can anyone please guide me???
regards,
pruthvi
You have to make a web service (SOAP) callout or an HTTP (RESTful) callout from the visualforce page to achieve this. Please see this link for more help: https://developer.salesforce.com/page/Apex_Web_Services_and_Callouts
If this answers your question, please mark this as the Best Answer for this post, so that others can benefit from this post.
Thanks,
Shashank
Are you sure about using web service (SOAP) callout or an HTTP (RESTful) because, I did not find any blog which says we can call SQL server stored procedure through apex code....
I am going through the link which you gave me.
Regards,
raj