Stack Overflow
Stack Overflow

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.

A procedure is a subroutine that does not return a value.

Do not use this tag for stored procedures.
Use tag instead. If question is about stored procedures in Oracle then you can also use tag.

2740 questions
0
votes
2 answers

Python 2.7: Issue with cv2 (opencv) DLL load failed: The specified procedure could not be found. (Windows XP)

I have been requested to make a Python file in order to capture screenshots at regular intervals on a minimal Windows XP machine (sadly), for obvious compatibility reasons I used Python 2.7.10 X86. The application works as expected on Windows 10…
Jean Meier
  • 33
  • 7
0
votes
2 answers

What's wrong with this simple block? PL SQL

i'm trying to run this simple anonymous block on TOAD but i get the following error. Can someone help me? That's the code: BEGIN FOR REC_CONF IN ( SELECT DISTINCT CONF.SCHEMA, CONF.TABELLA, CONF.CAMPO, CONF.TIPO_CAMPO, CONF.LUNG_CAMPO,…
Jackwiper
  • 3
  • 5
0
votes
1 answer

How do I validate the filters using substr/regex function and get results from stored procedure in Oracle PLSQL?

I need help in writing a procedure to retrieve the details of the employee when user perform search for either place or county or zip code (all 3 contained in the Emp_Address column by comma and space separated). Employee table: Emp_Address column…
Anitha
  • 77
  • 1
  • 2
  • 9
0
votes
0 answers

Reading and storing all files in directory using oracle procedure

I am trying to access some directory in C which is (C:/FilesDirectory) and am looking for an oracle procedure/script to fetch all files in this directory and insert them in a table in my database(insert files themselves). I created the directory…
TAM.G
  • 1
  • 2
0
votes
2 answers

MariaDB pl/sql to populate a table with dates from '1990-01-01' to '2000-12-31'

I attempt to create a procedure or function to populate a table name Time_Dim in MariaDB. DELIMITER / CREATE FUNCTION filltimeDim () BEGIN DECLARE vQuarter VARCHAR(6); DECLARE vMonth_Name VARCHAR(20); DECLARE vdate_id date; DECLARE…
comocoder
  • 84
  • 6
0
votes
1 answer

mariadb fonction, procedure error You have an error in your SQL

DELIMITER / CREATE FUNCTION filltimeDim () BEGIN DECLARE vQuarter VARCHAR(6); DECLARE vMonth_Name VARCHAR(20); DECLARE vdate_id date; DECLARE vyear_id CHAR(4); DECLARE vweekly_Name VARCHAR(20); DECLARE vMonth_Num…
comocoder
  • 84
  • 6
0
votes
1 answer

SQL Server stored procedures don't refresh even after refresh

Anytime I'm editing and debugging a SQL Server stored procedure, I'll make the changes, then refresh all along the line. I'll refresh folders: Stored Procedures, Programmability, the DB itself, all the way up to the server. Regardless of how far up…
jdosser
  • 143
  • 1
  • 7
0
votes
2 answers

How to access the HR schema objects through a user defined procedure in Oracle 18c?

I have given the code and the error messages I got when I try to create a procedure being user1. I try to access employees table in the sample hr schema in Oracle XE 18c. Can I know how to access hr schema objects via a user defined…
user12272059
  • 3
  • 1
0
votes
1 answer

Issue with "spool"-commands in PL SQL Procedure

I was trying to create a procedure within one of the Oracle DBs. Procedure is intended for my colleagues, so that everybody could export the result of the query in a csv-file. I was using "spool" commands. When running the code between BEGIN and END…
Anton FromButovo
  • 29
  • 3
0
votes
2 answers

CURSOR IN PROCEDURE PL/SQL

i have successfully created procedure for checking my stock item, here's the syntax : create or replace procedure check_stock AS CURSOR check_stock IS select category.category_name, item.item_name, item.stock from category join item on…
rumah makan
  • 11
  • 1
0
votes
0 answers

How use while loop in procedure for delete a few rows . SQL (Mysql)

I want to delete a quantity of rows in procedure . I tried do it like this ,but I did something wrong. BEGIN DECLARE counter INT DEFAULT 0; SELECT COUNT(*) INTO quantity FROM (SELECT A.idImages FROM images A WHERE A.Posts_idposts = id ) a LIMIT…
mattxml
  • 82
  • 1
  • 8
0
votes
1 answer

SQL Create view or procedure in a SUM query without adding new column?

Supposed I have some sample data in table_name_a as below: code val remark date ----------------------------------- 1 00001 500 111 20191108 2 00001 1000 222 20191107 3 00002 200 111 20191108 4 …
user12336707
0
votes
1 answer

Get DDL command from oracle database objects without using dbms_metadata

I am doing a procedure in the oracle database that has the function of performing a kind of inventory of the objects of the database. Basically I must get the DDL of objects of type table. For this, I am using queries from the bank itself as: select…
Arthur Luiz
  • 123
  • 1
  • 4
0
votes
1 answer

How to create package alias in h2

I am writing the test cases in java using h2 as in memory database. and I need to create a package and inside it there is a procedure. I am able to create a procedure using user defined funtions in h2 where I have create a java class and in it I…
Vikas
  • 107
  • 1
  • 10
0
votes
1 answer

Store a multi-byte character constant into a MASM byte array?

I'm trying to write a simple procedure which will assign a letter grade to a string variable based on a grade entered by the user which I've stored in a variable named "AGrade". I have written the statements like this: LGrade proc AGrade;dword…
Google Z
  • 5
  • 3
1 2 3
…
99 100