Questions tagged [procedure]
A procedure is a subroutine that does not return a value. Do not use this tag for stored procedures. Use 'stored-procedures' tag instead.
procedure
2,763
questions
1
vote
1
answer
29
views
in gnucobol, sub programs of one parent can't invoke each other
I'm currently trying to achieve a pattern to write modest these days' programs in cobol.
By these days' programs I mean a source file with a few variables and procedures visible to each other.
The ...
0
votes
1
answer
49
views
How to select several values into variables in PLSQL
I have this statement:
SELECT parameter,
VALUE
FROM TABLE(my_db.workplan.get_pp_params(in_pa_nummer => 'NR04640992', in_par_typ => NULL))
this is what I get back from the statement:
...
1
vote
0
answers
32
views
How to get max date value across multiple tables and different columns names into bigquery?
I need a SQL query or a procedure to get the max data value across multiple tables. I found the information into big query schema.
Now I need the max value of all date columns across all tables.
With ...
0
votes
1
answer
39
views
How to call snowflake stored procedure in databricks?
I need to call my snowflake procedure in Databricks. How to execute?
Databricks python code for call snowflake stored procedure. I'm getting "unknown function" error when trying this code:
...
0
votes
0
answers
33
views
Insights on Procedure in mySQL
I am trying to define a procedure that should run at midnight everyday.
CREATE PROCEDURE name
BEGIN
do something ;
do something 2 ;
do something 3 ;
END
I understand the need for delimiter in ...
0
votes
1
answer
25
views
Snake game, How to make the snake to not move in opposite directions?
I'm making the snake game and now doing the part where if you move up you can't move directly down and so on...
I think I wrote the code well and it'll work but the jump points are too big and I tried ...
0
votes
1
answer
28
views
Error when executing procedure to add columns to all tables
I have created a procedure to add a timestamp column to all the tables in my database. When I execute the procedure without tables it works correctly, but as soon as I create a test table and execute ...
0
votes
0
answers
12
views
decoded json list string not there
can amyone can help me with a decoded json list?
In the blocks below when the list is shorter I get error.
enter image description here
What is the best option to put a default text if missing?
Thank ...
2
votes
1
answer
104
views
Call procedure with parameter from HTML template in TMS WEB Core
I have a simple project in TMS WEB Core.
I want to create a series of buttons at runtime in a loop inside of my TWebHTMLDiv component and call the Delphi myFunc function based on the loop index of ...
0
votes
0
answers
27
views
Is there a way to grant SELECT access to a DB2 table through a stored procedure alone
We have a use case where we are storing some credentials in encrypted form within our warehouse. The decryption paraphrase is loaded at runtime through k8s secret, passed on to a stored procedure, ...
0
votes
0
answers
34
views
I tried to write a procedure that checks the number of times a letter (within an array) occurs in another array
I tried to create a “love calculator” by checking the number of times the letters T, R, U, E, L, O, V, and E (both lowercase and uppercase) are found in two names. I wrote it in a procedure so I could ...
0
votes
2
answers
53
views
Unknown system variable when calling Procedure in SingleStore
I've created the following procedure in SingleStore
DELIMITER //
CREATE OR REPLACE PROCEDURE updateColumnModelName(tableName TEXT, columnName TEXT) AS
DECLARE has_column INT DEFAULT 0;
DECLARE ...
1
vote
2
answers
25
views
Getting error while creating procedure for filtering data from a table
Create a MySQL procedure to declare a cursor to select last name, first
name, salary, and hire date from the EMPLOYEE table. Retrieve each row
from the cursor and print the employee’s information if ...
0
votes
0
answers
43
views
Difference between an "IS" or "AS" function/procedure declaration PL/SQL [duplicate]
When declaring a procedure/function in an ORACLE database, we can find this :
CREATE FUNCTION get_bal(acc_no IN NUMBER)
RETURN NUMBER
IS acc_bal NUMBER(11,2);
BEGIN
...
In the ...
0
votes
1
answer
63
views
Visibility of types inside a procedure (pl/sql)
i have some problems with a pl/sql procedure.
I'm tryng to collect a resulset of records from a query sql into a pl data collection.
The code is like this:
DECLARE
testProcedure TB_TESTPROCEDURETYPE;
...