A simple question..How to test procedure in SQL plus?
Posted on 2004-04-30
I have a procedure this is the def...
CREATE OR REPLACE PROCEDURE "SA"."RPTJSREPORT" (
JNum IN NUMBER DEFAULT NULL,
HearingType IN NUMBER DEFAULT NULL,
HearingDateFrom IN VARCHAR2 DEFAULT NULL,
HearingDateTo IN VARCHAR2 DEFAULT NULL,
CaseType IN VARCHAR2 DEFAULT NULL,
TempTableName IN OUT VARCHAR2)
I want to test this in sql plus. In the procedure it creates a global temp table which preserves the data on commit. After execution I would like to see the table...
I am not sure of the exact syntax.. This is what I want to do..
execute the procedure with parameters...
Show the table as select ( name from output variable TempTableName)
I may not be able to test any solution right away as server is unavailable...
But It should be a simple task for Oracle users.. let alone Experts!
Thanks in advance