Skip to main content
Question

run time parameters in custom menu.


Forum|alt.badge.img+6

Hi All  can I give runtime parameters when clicking custom menu. ie. inputs given by users at the time of executing menu.

for example.

can i incorporate below plsql block as custom menu.

DECLARE
  num1 NUMBER := &num1;
  num2 NUMBER := &num2;
  result NUMBER;
BEGIN
  result := num1 + num2;
  DBMS_OUTPUT.PUT_LINE('The sum of ' || num1 || ' and ' || num2 || ' is ' || result);
END;
/

Thanks in advance.

Hari

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings