How can I resolve the "could not find server" error when using execute(@sql) at [linked_server] with a stored procedure?

I have created a stored procedure in SQL Server to execute a PL/SQL script to a linked Oracle server using either sp_executesql or execute(@sql).

The former method works while the latter generates a "cannot find linked server" or "Server is not configured for RPC" error.

I need to execute a PL/SQL script to return an IEnumerable<T> using Dapper on the Oracle server, but I must use an SP in SQL Server to call the linked server.

I suspect a configuration issue, but I'm new to working with linked servers in SSMS.

The stored procedure is:

ALTER PROCEDURE [dbo].[Oracle_s] 
(
	@sql varchar(4000)
)
AS
BEGIN
	declare @result bit = 0;
	set nocount on;
	declare @temp nvarchar(4000) = 'SELECT * FROM OPENQUERY(LK_VPROD, ''' + REPLACE(@sql,'''', '''''') + ''')';
	declare @tsql varchar(4000) = REPLACE(@sql,'''', '''''');
	begin try
		--exec sp_executesql @temp;
		execute(@sql ) at [LK_VPROD];
		set @result = 1;
	end try
	begin catch
		SELECT ERROR_MESSAGE() AS ErrorMessage; 
		set @result = 0;
	end catch
	set nocount off;
	return @result;
END

How can I resolve this error and execute the PL/SQL script successfully through the stored procedure using the execute(@sql) at linked_server command?