Exam SnowPro Advanced Data Engineer topic 1 question 66 discussion

The following stored procedure has been created to load orders for a single date into a target table:

create or replace procedure uspLoadOrdersByDate ()
returns string
language javascript
execute as owner
as
'
sqlCmd = `INSERT INTO ORDERS_BY_DATE_TGT SELECT * FROM ORDERS_BY_DATE WHERE O_ORDERDATE = $dateToProcess`; sqlStmt = snowflake.createStatement({sqlText: sqlCmd}); res = sqlStmt.execute(); res.next(); return res.GetColumnValue(1);
';

Upon executing the following statements, the following error is returned:

set dateToProcess = '2020-08-02';
call uspLoadOrdersByDate();

Execution error in store procedure USPLOADORDERSBYDATE: Use of session variable '$DATETOPROCESS' is not allowed in owners rights stored procedure At Statement.execute, line 4 position 14

Making what changes will allow the procedure to execute successfully? (Choose two.)