Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrating from SQL Server to ORACLE using SqlDeveloper tool - IN OUT CURSOR

604466Oct 22 2007 — edited Oct 22 2007
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2007
Added on Oct 22 2007
2 comments
98 views