Questions tagged as 'oracle'

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

Insert using parameters in the C # application for the Oracle database error: ORA-01036: invalid variable name / number [closed]

I noticed that you have a lot of questions about this error but none solved my case the connection works normally, there is the method Insert (): public bool Insert(ArrayList arrAlunos) { vsql = "insert into ALUNOS_("...
asked by 31.01.2018 / 17:46
0
answers

Generate field Xml file in Oracle

I have a problem to solve: I have a table in Oracle 11g that stores the company entry notes, in this table I have a column of type CLOB that stores the complete XML file of the note, my mission is: get this column of the CLOB type with the XML a...
asked by 07.02.2018 / 11:34
0
answers

I can not do the load test

I'm doing a load test on an Oracle database using Swingbench software. The problem is that I can not create the load the wizard runs into several exceptions and I do the step by step as it asks for the documentation, I would like a help because...
asked by 29.01.2018 / 04:05
1
answer

How to display two tables in SQLDeveloper at the same time?

I'm not able to filter two tables at a time in SQL Developer at the same time. When I insert two tables into it, sqldeveloper does not show anything!     
asked by 25.01.2018 / 20:57
1
answer

Change automatic database field after a certain time

Well I have a field in my table that is called status, I need to have my bank update this field automatically if the visitor does not leave the company after 18:00. Does anyone know how I start? I'm using Oracle     
asked by 25.01.2018 / 13:29
0
answers

How to download MonkeyTalk

Apparently in 2015 Oracle bought MonkeyTalk, and left the download unavailable, the only thing about that on their site is a warning that they bought MonkeyTalk in 2015 link Is there no other way to download?     
asked by 02.02.2018 / 13:48
0
answers

export XML files stored in oracle database

Good afternoon! I have a problem at work to solve and I would like to know if there is any prepared script that can help me, I need to grab the XML file from input notes that are stored in a clob-like column in a table in the database and export...
asked by 26.01.2018 / 21:10
1
answer

How to run PROCEDURE and FUNCTION at the same time?

I have this plsql code and I must run at the same time: /*Testar se o codigo é valido*/ CREATE OR REPLACE FUNCTION TESTE1(cod number) RETURN BOOLEAN IS begin if(cod>0)then return true; end if; return false; end; /*varrer o b...
asked by 23.01.2018 / 17:08