How can I run an oracle stored procedure

FinalBuilder Discussion
1

I’m needing to make some changes to one of my build processes. The easiest way to handle this is to run a stored procedure on an oracle database which then produces a file that can be used further on in the build process.

I have no problems with writing the stored procedure however I’m not sure exactly how to use FinalBuilder to trigger this stored procedure.

There are no results returned from the actual procedure - it will simple create a file on the database server which will then be processed by FinalBuilder.

I have FinalBuilder 5 Professional.

Cheers

Paul James

2

Hi Paul

You should be able to use the ADO Execute Stored Procedure to do this, we don’t have Oracle here to test this so I’m afraid I’m unable to confirm if this works or not.