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!

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.

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
106 views