Please explain .. how about if the store procedure expects a Boolean Parameter (TRUE OR FALSE), but by default it is FALSE meaning if nothing is passed (NULL) it should be FALSE. Can you resolve this ? Thanks!
Write a stored procedure which runs via task (part of next chapter and will be released soon). This stored procedure will have insert/delete/update operation based on stream object 3. Setup the task to run on certain frequency plz send the code ofthis iam try but not work
JavaScript execution error: Uncaught TypeError: snowflake.createstatement is not a function in EMP_INSERT at ' var stmt = snowflake.createstatement({sqlText: command});' position 24 stackstrace: EMP_INSERT line: 3 why am i getting this error please advice
Very very useful and explained with very important points. Thank you
Glad it was helpful!
Excellent bro
thank you
@@VCKLYTech need your help on learning snowflake.. you are from bro?
Good Expiations
Nice explanation. How to define the default input parameter while creating stored proc. Can you pls help
I think define the argument/input parameter with default values is yet available in snowflake. Please correct me if I am wrong on this.
@@VCKLYTech I went thru lot of documentation but did not see anywhere about default values to stored proc.
Please explain .. how about if the store procedure expects a Boolean Parameter (TRUE OR FALSE), but by default it is FALSE meaning if nothing is passed (NULL) it should be FALSE. Can you resolve this ? Thanks!
Sure.
could please share the codes
Write a stored procedure which runs via task (part of next chapter and will be released soon). This stored procedure will have insert/delete/update operation based on stream object
3. Setup the task to run on certain frequency plz send the code ofthis iam try but not work
JavaScript execution error: Uncaught TypeError: snowflake.createstatement is not a function in EMP_INSERT at ' var stmt = snowflake.createstatement({sqlText: command});' position 24 stackstrace: EMP_INSERT line: 3
why am i getting this error
please advice
Javascript procedures are case sensitive hence, we have to use snowflake.createStatement
Why are you concatenating p_name and p_deptno
Will check and get back to you