procedure Questions
1
Solved
In some programming languages, it is possible to mark functions as deprecated or obsolete and then it can't be used or should be used with caution. Sometimes it even results in a warning message so...
Swipe asked 7/2 at 16:49
3
Solved
Trying to find out the stored functions and procedures on PostgreSQL. I found some of the solutions where "join" has been used. I am looking for an optimal solution/command to it.
Aten asked 12/5, 2016 at 7:1
2
Solved
As the title says, are procedures atomic in MySQL? i.e. would something like
for (..)
<check_if_row_has_flag>
for (..)
<update_row>
work atomically?
Interestingly, I couldn't find mu...
Anson asked 28/6, 2018 at 23:44
5
Solved
4
Solved
I am trying to write a procedure in delphi.
This procedure gets the name of TControl descendent element and then try to change some properties.
But when i try to do it, Delphi gives an error like:
...
9
Solved
I just want a quick way (and preferably not using a while loop)of createing a table of every date between date @x and date @y so I can left outer join to some stats tables, some of which will have ...
Nath asked 18/9, 2008 at 18:21
7
I need to know how to calculate the positions of the QR Code alignment patterns as defined in the table of ISO/IEC 18004:2000 Annex E.
I don't understand how it's calculated. If you take the Versi...
3
Solved
How can be find the location of procedure (function) in TCL. Under location I mean the source file in which it is declared.
I'm trying to read foreign source-code and can not find the declaration ...
2
Solved
I called a procedure in MySQL, but it is in an endless loop now! How to stop a running procedure in MySQL? The following is my procedure code：
drop procedure if exists my_proc;
DELIMITER $$
CREAT...
2
Solved
I'm using Postgres 12 and have written this procedure:
CREATE OR REPLACE PROCEDURE reduceStock(id INTEGER, soldQuantity INTEGER)
LANGUAGE plpgsql AS
$$
BEGIN
UPDATE inventory SET ProductStockAm...
Rascality asked 2/12, 2020 at 22:13
3
Solved
Does anyone know whether it's possible for a PL/SQL procedure (an error-logging one in this case) to get the name of the function/procedure which called it?
Obviously I could pass the name in as a...
2
Solved
Procedure FunctionX, Line 345
Invalid use of a side-effecting operator 'EXECUTE STRING' within a
function.
I get the above error when I execute a dynamic statement inside a function in SQL Se...
Manhole asked 30/9, 2015 at 14:30
0
I'm trying to encrypt and decrypt a CLOB. I have a test CASE below, which utilizes functions to accomplish this task and was taken from the following link.
Error while using DBMS_CRYPTO function to...
Fairlead asked 17/9, 2021 at 8:32
2
Solved
I'm trying to wirte a little log procedure for my database. I create a procedure with this statment:
create procedure prc_wirte_log (
in p_schema varchar(255),
in p_item varchar(255),
in p_mes...
Trample asked 19/9, 2018 at 18:34
4
Solved
I have some Persian dates in my sql server table with the following format:
1394/05/14
I have to use stored procedure to convert it into Gregorian date because I need to compare it with today's ...
Eberto asked 21/5, 2015 at 18:25
1
Solved
While fiddling with the performance impact of calling a procedure from another procedure vs. repeating the code in Postgres 13, I found that you can invoke other procedures by using either CALL or ...
Nosegay asked 26/5, 2021 at 17:11
4
Solved
I'm new in MIPS language and I don't understand how the functions (procedures) in the MIPS assembly language work. Here are but I will specify my problem :
What does:
jal
jr
$ra
mean in mips ...
3
Solved
If you will look at the code of FreeAndNil procedure you will see:
procedure FreeAndNil(var Obj);
var
Temp: TObject;
begin
Temp := TObject(Obj);
Pointer(Obj) := nil;
Temp.Free;
end;
What is ...
4
Solved
I have a question and maybe its simple (for you Gurus).
I'm transposing my SQL Paging class from C# to a MySQL Stored Procedure. In my C# home-made object, the query is dynamically built based of...
18
Solved
Generally speaking, we all hear about the functions or procedures in programming languages. However, I just found out that I use these terms almost interchangeably (which is probably very wrong).
...
Olcott asked 6/4, 2009 at 11:48
1
Solved
In PostgreSql procedure, I need to create a list of integers to use in a delete statement, as in the example:
DELETE FROM appointment_virtual WHERE appointment_id IN (list_delete);
I need help w...
Meldon asked 9/10, 2019 at 20:31
6
Solved
I've created a simple procedure. In this procedure i want to output some data. However where ever i put
set serveroutput on
it says
Error(26,5): PLS-00103: Encountered the symbol "SERVEROUTPUT...
1
When I try to compile the procedure with collection type as in parameter, I'm getting the error like
wrong number or types of arguments in call to 'P_AA'
-------Procedure created with in para...
Reproof asked 18/8, 2019 at 6:44
6
Solved
I would like to know the pros and cons of calling procedures with Call Keyword and without Call in VB.NET?
Private Sub ProOne()
' Code Are Here
End Sub
Private Sub Calling()
ProOne() ' I would ...
1
Solved
My question here would be... Why is it converting to int from varchar? I'm not sure what it is trying to do
CREATE PROCEDURE #myTestProcedure
(
@TransId VARCHAR(15)
)
AS
BEGIN
DECLARE @Result ...
Interstice asked 25/1, 2019 at 17:43
1 Next >
© 2022 - 2024 — McMap. All rights reserved.