Hi,
I created smartobject from a SQL stored procedure with linked Oracle server inside:
This smart object doesn't return anything but when I run this stored procedure under the same account I have for that Service instance I can see the data.
I will really appreciate any help.
Thank you
Hi svi0515,
Using Linked server won’t create any problem in result but make sure you are not using query whose result set schema is dynamic in nature.
For Example, if you are using Temp table you will be able to get the result in SQL server, but while creating Smartobject you will not get properties. And though you have create Smartobject result will not appear.
Hi,
I attached the file with my code this is a kind of stored procedure I'm using. Can you please confirm the smart object from it will work correct.
Hi svi0515,
Yes this Stored Procedure will work.
Yes, I did.
THank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.