Questions tagged as 'oracle'

Tagged questions
1
answer

Can I have procedures with the same name and number of parameters in the same package (ORACLE)?

Can I have a package with two procedures of the same name, number and type of parameters just diversifying the name of the parameters?     
asked by 26.10.2015 / 20:21
1
answer

Compare all the records in table "A" with each record in Table "B"

I am a programmer and rarely use a database, I came across an unusual situation of converting multiple .DBF files and saving everything in the database in their respective tables, however some files surpassed more than 3 million records, as a pr...
asked by 26.10.2015 / 23:52
1
answer

Debug function inside a package

I have a package with various functions and procs. How do I, using pl / sql developer, to debug? I would like to know how I go about the error and see what is being done. Using the pl / sql Tests tool I know I can debug. What happens is that...
asked by 03.12.2015 / 19:29
1
answer

Reverse engineering does not update new objects Oracle Data Modeler

I have a problem with Data Modeler. Etou using Oracle Data Modeler. I did reverse engineering to generate physical model. When I did the modifications in the database and wanted to update the template. The new objects did not come, only the upda...
asked by 28.05.2015 / 19:09
3
answers

Inserting column in Oracle table with conditional

I need to create a column in an existing table but need to do with a check condition if this column already exists in the database I did this way however it throws an error: DECLARE col_count integer; BEGIN SELECT count(*) into col_count F...
asked by 08.04.2015 / 19:38
1
answer

Timezone error when importing dump of Oracle 10g

My database server has failed and I need to restore a dump from a database. But when I try to run the tool imp from Oracle 10g x and it returns me the error 1882 - região de fuso horário não encontrada Follow the log of the tool imp   ...
asked by 02.07.2015 / 00:07
2
answers

Connect PHP with Oracle [closed]

I'm trying to connect PHP (WAMP) with Oracle but I get the following error:    Call to undefined function ora_logon () Code I'm using: $db = "(description = (address = (protocol = tcp) (host = www.servidor.com.br) //link omitido (por...
asked by 25.04.2015 / 17:36
1
answer

How to use column data from a query as a row in the datagridview?

I have a query with 3 columns that bring data from the Oracle database and I want to use one of these columns as a line in datagridview . There are 3 columns name , data and contagem de nomes , and in the Data...
asked by 04.03.2015 / 19:37
1
answer

Oracle tnsping ok, spring JdbcTemplate TNS: listener does not currently know of SID given in connect descriptor

I'm facing a problem, I hope they can help me, I'm developing a web application running on tomcat using Spring-mvc and data access with JdbcTemplate, the database is Oracle 11g. Within this scenario as a prache, I have two environments, in the d...
asked by 11.12.2014 / 16:25
1
answer

Decode in full select

Can I perform a decode on a select that returns all the data in a table and some of the other tables? In this select, I would like to do a decode for one of the columns of PP (request_peace), but as it does a full search I do not know if it i...
asked by 06.11.2014 / 20:26