Forum Stats

  • 3,875,889 Users
  • 2,266,986 Discussions
  • 7,912,370 Comments

Discussions

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

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.



How to make Database Actions to see missed 2 function parameters?

Best Answer

Answers