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
1 answer

Procedure expects parameter '@params' of type 'ntext/nchar/nvarchar' SQL Server

I have a problem with code in SQL Server. The error is: Procedure expects parameter '@params' of type 'ntext/nchar/nvarchar'. My code: CREATE FUNCTION porcentajeCadaUno -- Se ingresa las variables del procedimiento almacenado para calcular % -- …
Jhon Fredy Plazas Hurtado
  • 1
0
votes
2 answers

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

I created a Stored Procedure which has 2 filters in where clause. I have included one filter and am able to get the results.However, when am trying to include the second one, the procedure is not displaying any values. The user enters the parameter…
Anitha
  • 77
  • 1
  • 2
  • 9
0
votes
1 answer

PL/SQL: ORA-00947: not enough values

Im creating a procedure to display the n number of maximum and minimum salary for an employee. If i ll give 5 as input, the query will get me 5 maximum and minimum salary for an employee. For the above scenario, I have created an object with two…
Raja sekar
  • 79
  • 2
  • 11
0
votes
1 answer

Create procedure to automate insert from another table by max(date)

I am trying to create a procedure to insert missing rows from another table by max(date). I would then schedule a job to run every 5 minutes to update a remote table. I am unable to get my procedure to compile. I would like to add date format…
Gilly
  • 45
  • 7
0
votes
0 answers

Procedure does not exist. Error 1305 MariaDB

My server has been automatically updated from Mariadb 5.5.60 to 5.5.64. From that moment on, no stored procedure is executed. I get the error 1305: Procedure xxxx does not exist. I've been reviewing privileges for hours and I can't find the…
Guillermo Herrera
  • 1
  • 1
0
votes
0 answers

error shows when executing stored procedure using odbc

My powerbuilder application connect to Oracle timesten database using odbc. The application can connect to the databse and do dml (select, insert, update, delete) successfully. But when I executie a stored procedure, an error is shown "driver not…
Nazim Fathi
  • 1
0
votes
1 answer

PLSQL Prodecure to Select a single row from a table produces error PLS-00103

My codes goal is to cause a Phantom row. I understand the process but I'm struggling to get my first sql script to run CREATE OR REPLACE PROCEDURE PHANTOM IS DECLARE ENAME CHAR; ENAME EMPLOYEE%ROWTYPE; BEGIN SELECT * INTO ENAME FROM…
Daniel Wong
  • 3
  • 3
0
votes
1 answer

How to use is / as in procedure?

I use sql server, and have just switched to oracle. When I got to the procedure, I had a few questions with "IS / AS". I don't know when to use "IS" and when to use "AS". Please help me! Thanks end respect. sql navigator 7.1
Đoàn Hiển
  • 11
  • 2
0
votes
1 answer

How rollback all inserted record in an iteration in a loop

I want to insert a bunch of record in DB2 by a procedure and when an exception raises I want rollback all other insert before this insert and iterate loop for the next cursor record CREATE OR REPLACE PROCEDURE IMPORT_DATA_FROM_SIBA_ICMS2 (in…
hamidreza
  • 1
  • 2
0
votes
1 answer

How to validate given Input Parameters (of Type) in Stored Procedure in Oracle PL/SQL?

I need to validate the Input parameter (values sent by Front end Java application to DB procedure). For example, "User_id" input parameter has to be 5 alphanumeric with first 3 letters and last 2 numbers.("abc12", "gyh56") else raise an exception.…
Anitha
  • 77
  • 1
  • 2
  • 9
0
votes
1 answer

Tableau connecting to Teradata procedure with out parameters not showing

I need to save a few parameters into Teradata via Tableau, I created a Teradata procedure to do insertion but when I connect to the procedure in Tableau it kept on giving me error "xxxx stored procedure returned no result. bla bla". In order to…
Ling
  • 349
  • 5
  • 15
0
votes
1 answer

wrong number or types of arguments in call to P_AA

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 parameter as nested table------------ create or replace…
Raja sekar
  • 79
  • 2
  • 11
0
votes
1 answer

Replacing trigger with a procedure

I have a table t1 with fields id, name and date. When I update the date to a certain value I want to move that entry to another table t2 (Remove it in t1 and insert it into t2). I explicitly want to do this on an UPDATE operation and not a DELETE…
krise
  • 485
  • 1
  • 10
  • 22
0
votes
1 answer

Coldfusion Function convert into an Oracle view by using CASE WHEN

My application manage meetings. Each meeting is linked to a unit. So I have one table in my DB: MEETINGS and a view UNITS linked with the key ORG_ID. In the view for a same unit key "ORG_ID", it can exist several rows (with a difference on a field…
coeurdange57
  • 715
  • 1
  • 8
  • 29
0
votes
2 answers

Match rows from 2 table and update value of 1 column from 1 table to the other table if the value in the corresponding column is null

I have two tables as followed: Table A (with Column 1A and Column 2A) Table B (with Column 1B and Column 2B) I want to write a procedure that helps me do the following: Find matched rows of Table A and Table B, where 1A = 1B After that, for each of…
Eric Do
  • 5
  • 3
1 2 3
…
99
100