Skip to Main Content
Forums

APEX

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!

How can i get the return variables of GET method in PL/SQL procedure

Soukaina IDRISSIFeb 15 2018 — edited Feb 24 2018

Hi everyone,

I created a PL/SQL procedure named getInfoUser(id IN NUMBER), that call a GET method( which return 10 variables) of one particular RESTful Web Service, and i want to know how can i do, to return this 10 variables in my own procedure.

Thank you in advance for help.
This post has been answered by Pavel_p on Feb 21 2018
Jump to Answer

Comments

Timo Hahn

User, tell us your exact JDev version, please!
You normally get this message if the VO or collection behind the LOV has duplicate entries. If you now select one of the duplicate values you get this error as the e.g. selectOneChoice can only select one.
If you use a VO behind the LOV check if you have selected a primary key in the VO and rewrite your query that it returns unique values.

Timo

User508065-Oracle

JDev version is 11.1.1.9.0
Also, the VO behind the LOV has a primary key defined.

Timo Hahn

And the query for the LOV returns unique values?
If yes, do you have a reproducible test case?
Timo

User508065-Oracle

Yes, the issue can be reproduced on one of our Fusion env. I think it will be easier to show you via a zoom if possible.

Timo Hahn

Sorry, this is a public forum and we should keep it this way. Zoom is not an option here as it would not address everybody.
I'm not the only member that might be able to help you solve the problem.
Timo

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 22 2018
Added on Feb 15 2018
#apex-discussions, #plsql, #procedure
23 comments
2,740 views