Stack Overflow
Stack Overflow

Questions tagged [procedures]

262 questions
0
votes
1 answer

Python variable passing between procedures

I'm working on a code that firstly checks first letters of words from a list and letter counts only those that are letter 'U' Currently I'm facing issue with: how to make main procedure to pass the input to check_first_letter how to search the…
marcin2x4
  • 1,321
  • 2
  • 18
  • 44
0
votes
6 answers

C# .net Mnemonics and use in general

I'm just starting out with C# and to me it seems like Microsoft Called their new system .Net because you have to use the Internet to look everything up to find useful functions and which class they stashed it in. To me it seems nonsensical to…
Steve
  • 251
  • 1
  • 4
  • 9
0
votes
1 answer

NameError: name ' ' is not defined

I have this program and I would like it to run through each menu option. Basically the user logs in, the menu appears and pressing one works. However when I press 2 it tells me that 'Search Student is not defined' I don't understand what it is…
CV9
  • 5
  • 1
  • 1
  • 7
0
votes
1 answer

I want to write two plsql procedures. Get data in one procedure and print it from the second procedure

I need a list of values to be fetched from a table in one procedure and then the values to be passed to a second procedure. For ex. In A.prc I need to fetch data from a table and in B.prc I need to print the data that I fetched in A.prc. Thanks in…
Mihir Deshpande
  • 43
  • 7
0
votes
1 answer

Neo4j Procedure throwing error

I'm just starting to learn how to write procedures. My simple proof of concept still isn't passing muster when Neo4j starts up. Here is the code: import java.util.ArrayList; import java.util.stream.Stream; import…
Michael220
  • 193
  • 12
0
votes
2 answers

ORA-06550: line 1, column 65: PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:

My code CREATE OR REPLACE PROCEDURE myproc IS CurrDep Number; Tot Number; accm Number; Cursor Cur_lcd is select * from Courier_Scanner; Cur_row Courier_Scanner%rowtype; Begin for Cur_row …
Far
  • 341
  • 2
  • 11
  • 25
0
votes
1 answer

EF and stored procedures to populate entries for an Entity

Is it possible to define an Entity that is not mapped to a table in database and to use a stored procedure to return the entries? I found that I can use "Ignore" so the table in database is not created for an Entity, but how can I set a stored…
Fernando Pardo
  • 91
  • 9
0
votes
1 answer

ERROR 1066 (42000): Not unique table/alias: 'mp' OUTER JOIN in mysql

i have a problem converting my informix db to mysql. i got most things done but some functions just dont work. DELIMITER // CREATE PROCEDURE mw_getsvid(mwid INT) RETURNS INT BEGIN DECLARE svId INT; SELECT sv.ID INTO svId FROM messwert AS mw,…
itsme
  • 23
  • 4
0
votes
1 answer

Transpose columns to rows and sum up common column

Basically I have these columns in a temp table, I would like to group them by the dynamic columns (Payment method) to rows and sum up the tax amount based on the payment method. The Tax column will always be there, so you may consider it a static…
user3543512
  • 133
  • 1
  • 1
  • 13
0
votes
1 answer

mysql: use a procedure inside a trigger

I need to call a procedure that modifies root password inside a trigger. This is the procedure delimiter // create procedure foobar () begin SET PASSWORD FOR 'root'@'localhost' = 'foobar'; end// delimiter ; and this is the trigger delimiter…
James Biffi
  • 47
  • 5
0
votes
2 answers

Standalone Procedure Error in Cursor to a basic table

I'm trying to use a standalone external procedure to be ran from within a cursor, take a variable and throw it back to the procedure, where the procedure will insert the values into another table. Getting errors. PROCEDURE: CREATE OR REPLACE…
J Ben
  • 127
  • 9
0
votes
1 answer

execute procedures from column in table

Please help me with executing procedures in ORACLE. I have table with 3 columns: Create table PG_TABLE_1 (ID number(3), PROCEDURE varchar2(15), STATUS varchar2(4)); insert into PG_TABLE_1 values ('1','PROC_1','OK'); insert into PG_TABLE_1 values…
palo173
  • 13
  • 9
0
votes
1 answer

Creating Join to Display Values of One column from T1 which are not in T2 with some where comparisons

I am trying to create join in MYSQL Stored Procedure, one table is EMployeeMaster and Other Table is WeekRest. My join should result values of EMPID from EmpMaster for ONLY THOSE EMPIDs which EMPIDs do not exist in second Table WeekRest with some…
Shubham Pandey
  • 41
  • 1
  • 5
0
votes
1 answer

Splitting code in to procedures

I have code that got two inputs from the user and multiplied them. As you can see below. I tried to split things up in to separate procedures and then call them all at the end. I do though have some questions about what I did. After the first…
user7583447
0
votes
1 answer

IN parameter to Oracle Function

I have an Oracle function which accepts few IN parameters of number and varchar2 datatype and also it return a number datatype. Within the function, I'm selecting from a table with the IN parameters are applied in the 'WHERE' clause. By doing this,…
Robin clave
  • 608
  • 6
  • 16
  • 32
1 2 3
…
17 18