Hi,
When I am importing the metadeta of stored procedure having IN as well as OUT parameter in table definition branch. I am getting only one rown which is related to I/O as 'IN'. But It doesn't Provide any row for I/O as OUT..
As mentioned in my previous mail, this is my stored procedure:
CREATE OR REPLACE PROCEDURE test_procedure (
Test_Parameter IN DEPT.dname%TYPE,
Test_Cursor OUT sys_refcursor
)
AS
--TYPE Test_Type IS REF CURSOR RETURN DEPT%ROWTYPE;
BEGIN
OPEN Test_Cursor FOR
SELECT DEPT.DEPTNO DD, DNAME, LOC, test, DDATE,
EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, EMP.deptno ED
FROM DEPT,EMP
WHERE DEPT.dname = Test_Parameter
AND DEPT.deptno = EMP.deptno;
END test_procedure;
/
After importing metadeta in table definition for stored procedure, In parameter Tabpage, i must get 2 rows. one for IN parameter and other for OUT Paramater as follows
Column name key SQL type I/O Type length Scale
Test_paramater Varchar IN 4000
Test_Cursor -403 OUT
But when I am importing the metadata in my maching I am getting only one row for IN parameter, nothing for OUT parameter as follows:
Column name key SQL type I/O Type length Scale
Test_paramater Varchar IN 4000
Which fails the execution of job calling stored procedure having IN and OUT parameter..
Please suggest what should I do in order to get proper metadeta..
Regards
Neeraj Mahajan
Not getting out parameter in table definition
Moderators: chulett, rschirm, roy