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.
; 
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”.