All Questions
Tagged with java-stored-procedures javascript
3 questions
0
votes
1
answer
777
views
Stored Procedure - Snowflake - get details of all columns and rows
I am trying to get 4 column names from the table which has 10 rows and I want to loop through all rows in that table and pass those column values as parameters into some other stored procedure.
How ...
- 189
1
vote
1
answer
1k
views
I am trying to run a SQL query inside a Javascript Snowflake Stored Procedure but it isn't working and it keeps failing to initialise
I am trying to create a Javascript Stored Procedure in Snowflake where the javascript executes a sql query. I am new to javascript and I stole all of it from an existing one that already exists (and ...
1
vote
3
answers
1k
views
Replace all instances in a string
I have the below Snowflake Javascript Stored procedure where I need to replace multiple instances of a string in an sql statement.
CREATE OR REPLACE PROCEDURE MYSCHEMA.CountryDelete(COUNTRY VARCHAR)
...
- 21.4k