This SQL query illustrates how to call a specific Oracle stored procedure:
CALL "<ProcedureName>"('&USERNAME')
In this query:
-
ProcedureName specifies the name of the Oracle stored procedure you want to call.
-
USERNAME refers to the name of the attribute that uniquely identifies a user in the target Oracle Database system.