Skip to Main Content

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!

How to make Database Actions (SQL Developer Web) to see missed function parameters?

_Dima_Nov 19 2022

PL/SQL function was created:

CREATE OR REPLACE FUNCTION TOTAL
(
number1 IN NUMBER,
number2 IN NUMBER
) RETURN NUMBER AS
BEGIN
RETURN number1 + number2;
END TOTAL;

Above function was RESTful-enabled:
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
ORDS.ENABLE_OBJECT(p_enabled => TRUE,
p_schema => 'BOB_USR',
p_object => 'TOTAL',
p_object_type => 'FUNCTION',
p_object_alias => 'total',
p_auto_rest_auth => FALSE);

COMMIT;
END;

Database Actions shows that created total function doesn't have parameters but actually it has 2 parameters.

Screenshot from 2022-11-19 02-35-53.png
How to make Database Actions to see missed 2 function parameters?

This post has been answered by kdario on Nov 19 2022
Jump to Answer
Comments
Post Details
Added on Nov 19 2022
2 comments
107 views