Questions tagged as 'pl-sql'

Tagged questions
0
answers

How do I send an xml file via web service (Springboot) to PLSQL to execute an operation

I'm developing an application that gets a json and the transform me xml, however I do not know how to send that xml to plsql to run it.     
asked by 27.03.2018 / 18:55
0
answers

Is it possible to access a PL / SQL database from the console?

I've tried an interface, but I've seen several examples where the bank was accessed by a global call called sqlplus , does anyone know how to do this?    This is a remote connection     
asked by 29.03.2018 / 14:35
0
answers

Passing of cpf as a parameter in an insert / select

I have a process of creating a table that is very slow and would like to improve it. The view used in the process was created to use the CPF as a parameter, but when it is executed without the CPF or in join with another table it is extremely...
asked by 26.03.2018 / 23:42
1
answer

Find Relationship between Oracle tables

I would like to know if it is possible to find the tables and fields involved in a relationship in oracle, a query that would return a table as:    Table_Name, Column Name, Table_References       Official, char_id, Charges where the Empl...
asked by 26.03.2018 / 20:27
0
answers

Oracle - Lock that prevents SELECT

Lock that prevents SELECT The situation is as follows: An ERP application (Totvs) with several tables All these tables use as primary key a default field R_E_C_N_O_ The application (I believe) creates a new record common select max (R_E...
asked by 13.03.2018 / 21:16
1
answer

Batch with parameters in SqlPlus

Hello, I need to create a batch file that drops the user from the database, recreate and import the database with an existing backup. I have already created a routine that gives a drop in user and recreates with the permissions defined, th...
asked by 13.03.2018 / 21:51
0
answers

Execute PLSQL anonymous block with Hibernate

I need to run multiple function in Oracle with Hibernate FUNCTION ISNUMBER(value IN VARCHAR) RETURN NUMBER DETERMINISTIC AS RC NUMBER; BEGIN IF (value IS NULL) THEN RETURN 0; END IF; RC := TO_NUMBER(value); RETURN 1...
asked by 12.03.2018 / 19:12
1
answer

Error generating PLSQL file in oracle!

Code CREATE OR REPLACE PROCEDURE CRIARARQUIVOTXT AS Arquivo_saida UTL_File.File_Type; Dir_Arq VARCHAR2(60); Cursor cur_arq is Select f.NOME from tfuncionario f; BEGIN -- Diretorio do Arquivo Dir_Arq := 'C:\Users\xxxxxx\Documents...
asked by 09.02.2018 / 00:24
0
answers

Error in executing JOB in Oracle

I have a job that calls a procedure to generate a text file with all the names of employees in a company: job code: BEGIN BEGIN SYS.DBMS_SCHEDULER.DROP_JOB('job_criarquivo'); EXCEPTION WHEN OTHERS THEN NULL; END; dbms_sch...
asked by 09.02.2018 / 00:55
0
answers

Error generating file in oracle plsql

When I try to generate txt file I get the directory error message. Code CREATE OR REPLACE PROCEDURE CRIARARQUIVOTXT AS Arquivo_saida UTL_File.File_Type; Dir_Arq VARCHAR2(60); Cursor cur_arq is Select f.NOME linha from tfunciona...
asked by 09.02.2018 / 01:14