Questions tagged as 'plsql'

Tagged questions
2
answers

Error "PLS-00306: wrong number or types of arguments in call to 'TEST'" when invoking Java an Oracle function with parameters of type BOOLEAN

I'm trying to call an Oracle function from Java, and I get the following error message:    java.sql.SQLException: ORA-06550: line 1, column 13:   PLS-00306: wrong number or types of arguments in call to 'test'   ORA-06550: line 1, column 13...
asked by 26.01.2017 / 22:17
2
answers

Convert a stored procedure in SQLServer to Oracle

I need to pass that Stored Procedure to Oracle , I made the same logic by passing it to Oracle , but it sends me an error in OFFSET . CREATE PROCEDURE [Produccion].[MostrarCategorias] @NumeroPagina INT, @RegistrosPorPagina INT AS BE...
asked by 09.12.2016 / 15:26
2
answers

Undeclared Bind Variable - PL / SQL

I am programming a PL / SQL for the first time, and at the time of executing it it tells me that there is a Bind variable that is not declared, but it is, it would be the variable vFhfechax : Code: DECLARE vFecha_proceso V...
asked by 15.11.2016 / 13:20
1
answer

Oracle stored procedure that returns records

I am doing a stored procedure on the HR data base in pl / sql which returns me records. CREATE OR REPLACE PROCEDURE HR.Mostrar_Paises (continente NUMBER) IS v_rut VARCHAR(100); BEGIN for c in(Select Country_Name into v_rut from HR.COUNTR...
asked by 12.12.2016 / 00:57
1
answer

TRIGGER to prevent deleting record with a specific identifier

I'm doing a job with PL / SQL, oracle and sqldeveloper and I have a table to which I want to create a trigger that prevents me from deleting a record that has an id in the field 1. I do not know how to do it.     
asked by 19.05.2016 / 22:54
1
answer

Call several stored procedures inside another

I have a question about how to call several stored procedures inside another in Oracle. I tried to call them in the following way, but I only run the first one. Does anyone know how I can make the call for all three to run? I am using Oracle PL...
asked by 08.02.2017 / 18:58
2
answers

DBMS output is not displayed in Oracle SQL Developer

For some reason, when executing the following code, the result of the query is not shown by the output of dbms. The same code has been tested on another PC and it works. For the script output shows that everything went well:    PL / SQL proce...
asked by 23.11.2017 / 09:26
1
answer

ORACLE 11g Execute Trigger

How do I assign privileges to a user to execute a trigger ?, I need to know if a trigger can be executed and how to assign privileges if possible     
asked by 25.07.2017 / 22:01
1
answer

How can I implement this in the database?

Good, this is what he asks me for a table emple-depart-presupuesto We must ensure that the spending on salaries of a department does not exceed 50% of the current budget. CREATE OR REPLACE TRIGGER SALARIO50 BEFORE INSERT OR UPDATE ON emple...
asked by 14.06.2017 / 00:11
1
answer

Incomprehensible error [closed]

I get an error when executing the following code: CREATE OR REPLACE PROCEDURE ListaPrimos (n1 IN number, n2 IN number) AS metodo number; BEGIN if n1<n2 then metodo := n1; while (metodo <= n2) loop...
asked by 12.04.2017 / 12:14