Skip to Main Content

Data Science & Machine Learning

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ROracle, oracleProc, return value or output parameter handling

BG4GRAPHJun 27 2017 — edited Jun 29 2017

Hi,

@Mautro Pagano was informed in his post a year ago about the calling of procedures not being implemented in ROracle 1.2.2. It seems that ROracle 1.3.1 has some more functionality; I was at least able to call anonymous blocks.

However, I would need to pass return values or output parameters. Is this implemented? Could you give syntax examples?
I would be much obliged!

Yours, user8632123.

This post has been answered by Sherry Lamonica-Oracle on Jun 27 2017
Jump to Answer

Comments

JaiG
There's no way to do this out of box. I'd suggest using a drop-down prompt with multi-select enabled (which is probably the only other solution).
994691
Even I got the same answer from other's. Thank you.
And I have other threads opened for Presentation Variable in OBIEE reports, Needs to plot the values in x-axis linearly in obiee,Exporting to PDF in OBIEE 11.1.1.6. I am waiting for some one to help me out of it. Can you please suggest me your views, If possible.
Once again thanks for your response.
998980
Try to cast(datefield as char(9)) and set it to be either a multiselect prompt or an edit box (with a default set there)

That should make multiselect a bit easier.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 27 2017
Added on Jun 27 2017
2 comments
2,631 views