Rob's Blog

24/2: Calling Oracle Stored Procedures from Lotus Notes or Domino

I am currently writing an application for one of my clients that creates new projects in the Oracle eBusiness Suite ERP from the Lotus Notes client.  Oracle have public APIs written in PL/SQL that you must use for the task.  I created a PL/SQL "wrapper program" to call the APIs and called this as a stored procedure.

When this application is complete, I plan to write an in depth article on the techniques I used.

However, in the meantime, I thought it was worth posting the syntax that I used to call the stored procedure with both input and output parameters.  The documentation for calling a stored procedure is a little sparse.

So here is an example stored procedure.  You could call that using an anonymous block like so.  The LotusScript code to call that stored procedure using the LC LSX is here.

Finally, I used an on-line book to learn the fundamentals of PL/SQL which you can find here.  I plan to buy that book because I'll be using Pl/SQL again.