Loading...

RE: How do you call Oracle Procedures with the qSI webparts?

RE: How do you call Oracle Procedures with the qSI webparts?

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?

#4827
Anonymous
Anonymous
Participant

Hi Kathy,

   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.

CREATE

OR REPLACE PROCEDURE HR.GetEmployee

(

p_LAST_NAME

OUT EMPLOYEES.LAST_NAME%TYPE ,

p_FIRST_NAME

OUT EMPLOYEES.FIRST_NAME%TYPE

)

AS

BEGIN

SELECT

LAST_NAME

,

FIRST_NAME

INTO

p_LAST_NAME

,

p_FIRST_NAME

FROM HR.EMPLOYEES;

END

and this is how I set the QWP to call the stored procedure created above.

; QWPOracleSP.png

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.

Thanks,

If you consider that the answer was helpful please don't hesitate to mark it as "Answered”.