Migrating from SQL Server to ORACLE using SqlDeveloper tool - IN OUT CURSOR
604466Oct 22 2007 — edited Oct 22 2007Hi All,
I am new to Oracle. I am asked to migrate a database from SQL Server to ORACLE. I have migrated all the SP's and functions except 2. I am facing the following problem. Pls do reply me if anyone knows the solution since I am struggling for the past 2 days for these two functions
the function is as follows in ORACLE.
create or replace
FUNCTION ABC
(
AA IN VARCHAR2,
BB IN DATE,
CV_1 IN OUT SYS_REFCURSOR
)
When I tried to call from some other function its showing me an error.
I called from another function as follows:
ABC(CC,DD,CV_2);
Shall I know how to call the above function? I feel someone has faced the same problem before. Thanks in advance for the help.
Thanks,
Srinivasan.T