I have an Oracle Stored procedure that I can run by selecting the Stored Procedure data provider option and filling in the paramaters.
The problem is that it updates a table (which I then query in a seperate data provider) however it does not return any data. Because of this it won't save and I have to recreate it each time.
We had the idea to have an OUT value so it would return just one value and therefore keep the provider, however the Out value appears as a provider and I don't know what to insert.
Any ideas would be appreciated.
The problem is that it updates a table (which I then query in a seperate data provider) however it does not return any data. Because of this it won't save and I have to recreate it each time.
We had the idea to have an OUT value so it would return just one value and therefore keep the provider, however the Out value appears as a provider and I don't know what to insert.
Any ideas would be appreciated.