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.)
Select 2 answers.
Purchase Full Access to view answer options & explanation
The first 38 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 126 questions.
