Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

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!

requestValidationFunction - Can this be used for ORDS REST, or is it just for APEX requests?

Mike TotemicOct 6 2016 — edited Oct 7 2016

Should I be able to use the requestValidationFunction feature in the defaults.xml for ORDS REST requests?

I can't get it to work.

entry in defaults.xml :-

<entry key="security.requestValidationFunction">mike.verify_access(p_url => :URL )</entry>

<entry key="security.validationFunctionType">plsql</entry>

Function created in mike schema:-

create or replace function verify_access(p_url varchar2) return boolean is

begin

    return false;

end verify_access;

grant execute on mike.verify_access to public;

I've restarted the glassfish server and the instance_pu.xml pool is correctly configured. I also have PL/SQL gateway installed.

I was expecting every REST request to fail as the function is returning false. However, they all work.

I'm using ORDS version 3.0.7

1) Could you please confirm whether I can use this feature for ORDS REST requests?

2) If I can, what am I doing wrong?

3) If I can't, is there anything else I van use to validate the URL/METHOD for every API request without having to place code in every API request?

Thank you,
This post has been answered by Mike Totemic on Oct 7 2016
Jump to Answer

Comments

Robb Salzmann
Hi Shivendra

From Pg 2-1 of the WebLink Scripting Guide:
All the Hyperion FDM objects are supported in Import scripts except the Hyperion FDM “API” object.
If you need to populate 3 columns in your export from one column in your import, its easy, no scripting needed.

In your input format you simply refer that one column for each of the dimensions that need it's information.


It looks like you and James are on the same project. Help me help you, describe what you are trying to accomplish with this script. Why are you looking up maps during an import?

Regards,
Robb Salzmann
shiv2
Thanks!!

Edited by: shiv2 on Sep 16, 2011 8:56 PM
shiv2
Hi Robb,

"It looks like you and James are on the same project" That is correct.

OK. In requirment we have three-four column based on these column we need to derive few other column. We want to do spilitting and validation in Import itself. This is mainly a Validation requirment.

There is one column which may have 12,13,14,17 or any other number of character in it. first three will represent one dimension but exact value be a mapped result based on these three digits.


There are many validation based on the number on charaters and most importantly we don't want to process other column is validation get failed at any stage.

Do we have anything like Import Action? Probably we want to change that script. Or if we can write something like integration script. We need every column to be processed in one shot.

I don't think it is self explantry. Can we have your email please?

Thanks,
Shivendra

Edited by: shiv2 on Sep 16, 2011 8:52 PM
Robb Salzmann
Hi Shiv,

I'm not going to post my email address. I'm not hard to find, but you'll have to do a little work do to so.

Also I prefer to help you here where other people can benefit from the dialog. Continue to post your requirements and questions and we can get it done here.

Please provide more specifics around your question above to help me understand it - as its worded now, I'm not sure I understand what you're asking here.

Regards,
Robb Salzmann
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 4 2016
Added on Oct 6 2016
1 comment
420 views