Home › Forums › QuickApps Forum › How do you call Oracle Procedures with the qSI webparts? › RE: How do you call Oracle Procedures with the qSI webparts?
If you got the Text command to work fine with Oracle then here is a sample about how to create a Stored Procedure and use it from QWP.
I use HR Oracle database that gets installed with Oracle 10g Express Edition.
OR REPLACE PROCEDURE HR.GetEmployee
OUT EMPLOYEES.LAST_NAME%TYPE ,
and this is how I set the QWP to call the stored procedure created above.
I'd recommend you to try the best product ever made for making Oracle database work easy:
Quest Toad for Oracle.
Please let me know if you have any questions.
If you consider that the answer was helpful please don't hesitate to mark it as "Answered”.