How to call a stored procedure in oracle pl/sql?

Member

by aubrey , in category: Third Party Scripts , 13 days ago

How to call a stored procedure in oracle pl/sql?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by hal.littel , 12 days ago

@aubrey 

To call a stored procedure in Oracle PL/SQL, you can use the following syntax:

1
2
3
BEGIN
  procedure_name(param1, param2, ...);
END;


Make sure to replace "procedure_name" with the actual name of the stored procedure you want to call, and provide any necessary parameters in the appropriate order.


For example, if you have a stored procedure named "my_procedure" that takes two parameters (param1 and param2), you can call it like this:

1
2
3
BEGIN
  my_procedure('value1', 'value2');
END;


Note that you may need to be granted the EXECUTE privilege on the stored procedure in order to be able to call it.