Skip to Main Content

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!

save updates of multiple rows in editable IG [APEX19.1]

User_MN2SUJun 18 2019 — edited Jun 18 2019

I have a column called updated_date, and I wish to update this column when user edit and save other columns in the role. The problem is that when user edit 3 rows, then only the value of the updated_date of the last edited row gets updated.

Is there a way i can update these three roles at the same time? For my pl/sql code, i just use a simple update statement update [table]  set [column]=[value] where ROWID=:ROWID. Thank you very much!!

Comments

vladodias

Hi mate,

I'm assuming the value of "http://host:port/tokens" is not in your configuration, i.e. it is purposely edited in the post for information security reasons... otherwise the problem is probably there...

That said, note that OAuth 2.0 is a complete rewrite of OAuth 1.0 from the ground up, sharing only overall goals and general user experience. OAuth 2.0 is not backwards compatible with OAuth 1.0 or 1.1, and should be thought of as a completely new protocol.

Now, OWSM supports single-user OAuth use case, which requires providing partial support of OAuth 1.0 protocol in OWSM to use OAuth1 type of access token and token secret to secure the request to an API. OWSM provides new OAuth1 client policy which allows applications to use Twitter API using the statically generated consumer and access tokens. Retrieval of access token is not done by OWSM policy.

Oracle A-Team blog entry is for OAuth2 and I don't think it will work for your case... You should follow the link below...

10.8.1 About OWSM Integration with Twitter OAuth server

https://docs.oracle.com/middleware/12213/owsm/security/GUID-13F43DB4-C837-42C2-B6C5-6D6E07266415.htm#GUID-04F6A9C8-3EEC-…

Cheers,

Vlad

User_9VIX3

Vlad,

We are on version 12.2.1.0.0 and do not see any OWSM policy supporting OAuth1.0

Is there a patch we need to apply for this policy to be visible

Appreciate your help in advance.

Thank you,

Deepti

vladodias

Hi Deepti,

I can see it on my JDev 12.2.1.3... I'm unaware of any specific patch just to add the policy...

You might have to follow all the steps to upgrade to 12.2.1.3... see note below...

https://docs.oracle.com/en/middleware/lifecycle/12.2.1.3/fupss/upgrading-soa-suite-12c-bam-previous-12c-release.html#GUI…

Note:

If you are upgrading from a previous 12c release (12.1.3.0, 12.2.1.0, or 12.2.1.1), you must complete all of these tasks to upgrade to 12c (12.2.1.3.0) . Do not attempt to update the existing domain by installing the 12.2.1.3.0 distributions into the same Oracle home. Moving the domain to 12.2.1.3.0 is not a patch set installation.

pastedImage_0.png

Cheers,

Vlad

1 - 3

Post Details

Added on Jun 18 2019
3 comments
288 views