Skip to Main Content
Forums

Oracle Forms

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!

ORACLE 6i PROCEDURE AND ORACLE REFCURSOR

3145417Jul 19 2018 — edited Jul 20 2018

Hi everyone,

I have a form in 6i, I created in program units a procedure.

I want to called from this procedure a funcion from my oracle database, which is a refcursor result. How can I do that?

This is my procedure in forms 6i, i tried to open the cursor inside another cursor, and then get the columns results, but there is an error,

1.JPG

2.JPG

If I run the function in the database, the result is correct. But forms mark errors.

3.JPG

Thanks!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2018
Added on Jul 19 2018
#forms, #moved-from-devops
2 comments
766 views