Questions tagged [procedures]
262 questions
1
vote
1 answer
Handle exceptions on procedures PL/SQL
Hi I would like to handle exceptions on my procedures to make it more useful.
My procedure adding occupations and it's wage, here is table:
CREATE TABLE Occupations(
id_oc NUMBER(2),
Name_oc VARCHAR2(20) CONSTRAINT OC_name_cc NOT NULL ,
Min_wage…
Zomfire
- 193
- 1
- 3
- 15
1
vote
2 answers
Why is my SQL procedure returning the entire table?
DROP PROCEDURE IF EXISTS STUDENTS_BY_STATUS;
DELIMITER //
CREATE PROCEDURE STUDENTS_BY_STATUS(status VARCHAR(10))
BEGIN
SELECT BannerId, Name FROM STUDENT WHERE Status=status;
END //
DELIMITER ;
CALL STUDENTS_BY_STATUS("Freshman");
My…
Kyle
- 793
- 6
- 24
1
vote
1 answer
PASCAL - Call a procedure from another function
I have this problem.
Im at the End of this Function:
FUNCTION ToString(Liste : Pokemon) : String;
VAR
RES : STRING;
BEGIN
ClrScr;
TextBackground(Green);
Writeln('DER POKEDEX:');
Writeln;
WHILE (Liste <> NIL) DO
BEGIN
RES := …
user7285912
- 201
- 3
- 12
1
vote
8 answers
C++ Function Conventions?
Just had a 'Fundamentals of Programming' lecture at uni and was told that the convention for using/declaring functions is to have the main() function at the top of the program, with functions/procedures below it and to use forward declarations to…
Saladin Akara
- 2,518
- 6
- 30
- 50
1
vote
1 answer
MySQL procedure doesn't recognise tables
It does not recognise the tables that I created above the procedure and it says: unknown table "tourstats" in field list.
The table tourstats contains no data intentionally because I insert data with the call of the procedure and when I execute the…
1
vote
0 answers
Stored procedures for neo4j in clojure
I have a question about stored procedures in Neo4j. I already succesfully wrote a few procedures in Java and got them working with Neo4j 3.0.1. However I would like to try to write a procedure in other JVM laguage-Clojure. As I am not so familiar…
EvaJa
- 21
- 2
1
vote
3 answers
C# issue with an Oracle package
I am have an issue with a simple procedure in an Oracle package. There are other procedures that I am using in the package that work fine. The other packages us Cursors. This one uses a Return. I am not able to get the code to get past…
MeGreeny
- 49
- 5
1
vote
3 answers
How to view/verify a procedure result?
Can someone explain how to see the results of a procedure, everything is working fine and the code is valid, executed and compiled with no errors. Now how can I see the results as Query or anything.
The ex procedure is about sum of salary.
CREATE…
Elisabeth_c21
1
vote
1 answer
Neo4j creating a node in a procedure
Wondering if there is a configuration i need for my transaction so that its not read only...
I get an error when creating a node in a procedure. The error is
Caused by: org.neo4j.graphdb.security.AuthorizationViolationException: Write operations are…
Phil
- 21
- 3
1
vote
3 answers
PL/SQL call to procedure
I wrote a PL/SQL procedure to update the salary of the table Employee
create table Employee
(ID VARCHAR2(4 BYTE) NOT NULL,
First_Name VARCHAR2(10 BYTE),
Last_Name VARCHAR2(10 BYTE),
Start_Date …
kulercan
- 15
- 1
- 1
- 6
1
vote
2 answers
How to create a trigger to run a procedure at a certain time?
I need to know if there is any way to create trigger to execute procedure on certain time like :
create trigger Fire
when sysdate = 1-oct-2015
execute (procedure);
I hope you understand me and please provide any solution how I can do it
alaadin ibrahim
- 23
- 1
- 2
- 8
1
vote
1 answer
MVC database first EF imported SPs returning Complex types how and where to call it
I'm new to MVC and I use DB first approach and Entity Framework. I have imported my custom Stored Procedures that are returning mostly complex types. So far OK.
I see also code - object created in Context.cs. Now where (in a Controller?) and how…
George300
- 23
- 5
1
vote
2 answers
Dynamic objects with an event handler - Delphi
I have two components created dynamically, a button (btnEnter) and an edit (edtID)- where the user will enter their user ID. What I want is for the program to verify whether the user has entered a valid ID when they have clicked the button.
The code…
Visiobibliophobia
- 63
- 3
- 10
1
vote
1 answer
Xml bulk insert in oracle table
Im new to oracle,
what im trying is,
I have an xml, i try to insert the same in a oracle database table, i have formed a query, when i try to insert it. i get some Error like
Error report -
ORA-06550: line 35, column 84:
PL/SQL: ORA-00933: SQL…
ConquistadorAravinth
- 272
- 1
- 2
- 15
1
vote
0 answers
MYSQL Compiling procedures doesnt throw errors
I am compiling my stored procedures in MySQL and they contain errors. Still the compilation process completes successfully. Is there a way I can use so that it throws error on compilation if it contains some?
Darshan Patel.
- 3,132
- 1
- 11
- 10