Questions tagged [procedure-definition]
The procedure-definition tag has no usage guidance.
14
questions
1
vote
1
answer
269
views
SQL query to get the order of procedures based on their dependent procedures
i have this query to get all sp's and depending(nested) sp's on those sp's. I need to create all these procedures on another database . Any idea how to get them in the correct order.
select distinct ...
- 89
0
votes
0
answers
235
views
How can I write procedures that I can loop over to insert a series of files into my database?
My goal:
Insert a series of csv files into my database by creating procedures for each individual table and then looping over them. My csv files will all be named very similar to this:
...
- 273
0
votes
1
answer
485
views
Insufficient privileges as a definer of package
I cannot run a procedure within a package with a user that also defined it unless I specify "authid current_user" for some reason. Here is my original code that produces insufficient privileges error
...
- 1
5
votes
4
answers
3k
views
How do I compare large stored procedures?
I want to compare stored procedures that should be identical in several different databases, by retrieving and comparing the definitions from sys.sql_modules.
Currently I'm thinking about ...
- 750
0
votes
1
answer
31
views
Procedures In Oracle [closed]
--Procedures Exercise:
create or replace procedure Display
is
cursor ABC is
select empno, ename, sal
from emp
where deptno=10;
emp_rec ABC%rowtype;
Begin
Open ABC;
Loop
fetch ABC into emp_rec;
exit ...
0
votes
2
answers
857
views
ORA-01422 Error Occurred When I Call Procedure with Number Parameter
I want to write PL/SQL Procedure that updates salary which is less than 2000. I wrote this procedure.And when i call it with integer id 'ORA-01422: exact fetch returns more than requested number of ...
- 145
1
vote
3
answers
11k
views
How to use DAY/WEEK/MONTH/YEAR constant as parameter in stored procedure?
Assume I have a table looks like this:
Scores {
Id uniqueidentifier,
ScoredAt datetime,
Value int
}
Basically I want to create a stored procedure that works similar to this DATEDIFF(DAY, ...
- 123
0
votes
2
answers
6k
views
create a stored procedure if it doesnt exist using a ddl in db2
My requirements are,
I want to create a ddl script which will check if a stored procedure exists on DB, if yes then drop it and recreate it.
What I tried is,
IF EXISTS (select procname into ...
- 101
0
votes
1
answer
362
views
Error while creating procedure
This is my procedure:
DELIMITER $$
CREATE PROCEDURE sp_test_final6()
BEGIN
INSERT INTO `chef_ratings`(`chef_id`,`avg_total_no_votes`,`avg_total_rating`,`no_of_votes`,`...
- 131
1
vote
1
answer
8k
views
"Access denied for user" error when creating a procedure
When I request my database server (MySQL), with "show grants for current_user"
I notice that I have the grant to execute procedure:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK ...
- 177
1
vote
1
answer
2k
views
What is wrong with this a MySQL 5.6 procedure definition? Use a variable for table name [closed]
Just can't understand why it's throwing this error?
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ...
- 121
1
vote
1
answer
635
views
Oracle, Stored and External procedures
Could someone give me a brief explication about these two mechanisms in oracle : stored and external procedures.
Are they distinct ? Are they differ when we integrate in some language (Java, C++ or C ...
- 115
1
vote
2
answers
535
views
ORM-style server-side programming languages (OO replacement for PL/SQL?)
Good evening,
Is there an Object Oriented replacement for PL/SQL, allowing server side procedures to be written [and then called client or server side]?
(for MySQL, PostgreSQL, Oracle or etc.)
- 391
0
votes
1
answer
282
views
How to find "outer join in the where" syntax in SQL 2005 using cmptlevel 80?
Well last Christmas I was very happy, because we ceased support for SQL Server 2000.
I could stop twisting my brain and use friendly analytical functions. (Believe me, when it comes to migrate stored ...
- 12.1k