Questions tagged as 'oracle'

Tagged questions
1
answer

How to execute procedures inside another? [duplicate]

I have this procedure where I save within a cursor all the other procedures that need to be executed, then I scroll the cursor putting the procedure names inside a variable. How do you execute these procedures that have the name inside the...
asked by 10.07.2015 / 18:43
1
answer

Determining value within a pivot

I have a query where you are doing a pivot and it is bringing the correct records per month, however I would like to validate the amount of records per month that shows only employees who have >= 16 in every month! Today the qu...
asked by 18.09.2015 / 19:00
1
answer

How to check the constraints on the bank

Hello, how do I check if my constraints are linked in the entire bank? I need a query for Oracle and SQL Server.     
asked by 14.07.2015 / 20:36
0
answers

Error creating JOB in Oracle 11g

When I create a job in oracle this error is appearing.    ORA-01882: timezone region% s not found. How do I solve this problem?     
asked by 19.06.2015 / 15:45
1
answer

Display numeric values without scientific notation in Oracle select

I have to make multiple selects in Oracle using SQLPLUS displaying various information to be stored in text file. Some tables have numeric fields of type NUMBER (19). Some of these fields have values that are too high so that Oracle views them i...
asked by 19.03.2015 / 16:21
1
answer

OracleException is not triggered!

Someone has already encountered the following problem: When an error occurs that should be of type OracleException, but in its place an Exception is triggered, then the oracle processing is not applied because of this (the "..." are deprecated i...
asked by 26.02.2015 / 22:58
0
answers

ORA-12154 TNS: could not resolve the connect identifier specified

I am having problems when an application tries to connect to the database, I get the ORA-12154 TNS error: could not resolve the connect identifier specified. When I tinker or try to connect via pl / sql developer by sql plus everything happen...
asked by 28.04.2015 / 15:55
0
answers

Call sql server procedure via JDBC that returns cursor

I am not able to call a SQL Server procedure in java that returns a cursor. That's possible, does anyone have an example? For Oracle, you can use the example link . But I need it on SQl Server.     
asked by 02.04.2015 / 20:36
2
answers

Remember username and password for an Oracle ODBC connection

I am connecting an Oracle database with an Access database through Oracle ODBC Driver 11.2 . The problem is that every time I access the database in Access, the Oracle driver requests authentication: Is there any way to remembe...
asked by 29.10.2014 / 17:22
1
answer

Execute Immediate with line breaks getting Invalid Package

I'm creating a package dynamically ie: DECLARE vpackageletras VARCHAR2(2000); vvalorpossuia VARCHAR2(10); vvalorpossuib VARCHAR2(10); BEGIN IF letras.possuia THEN vvalorpossuia := 'TRUE'; ELSE vvalorpossuia := 'FALSE';...
asked by 21.10.2014 / 22:51