What is OraOLEDB? What is your role?
For example, there is an error here in the work system that only appears the OraOLEDB error, what are the reasons?
Questions tagged as 'oracle'
1
answer
I compile a package and it gives errors. Error location is wrong
After compiling a package, you get this error message:
249/36 PLS-00103: Encountered the symbol "TS_ODO" when expecting one
of the following:: =. (@%; The symbol ":=" was substituted
for "TS_ODO" to continue.
250/34 PLS-00103: E...
asked by
10.12.2015 / 13:17
1
answer
Deleting Oracle OBJECT_TYPE
Good afternoon.
How do I pay for an OBJECT_TYPE from my OWNER?
I need to delete this object_type, since it is giving SYNON error
asked by
08.06.2018 / 18:02
1
answer
JDBC CallableStatement: Application hangs when calling procedure [closed]
When I run a procedure on the application, it crashes, but on the database it executes normal.
This is the way I use to call procedure :
public int incluir(TOCompra compra) {
try {
PreparedStatement ps = BancoDados.getConexao...
asked by
24.10.2015 / 00:39
1
answer
insert with select if the field is null
I have this TODAY in JAVA running but I need to implement a new routine:
public void gravarLogAbonoUnificado(TbLogAbonClickUnic entity,
RetornoAuxDto auxDto) {
STRING SQL = "INSERT INTO" +
"TB_...
asked by
13.11.2018 / 14:02
1
answer
___ ___ erkimt OraOLEDB - What is ______ qstntxt ___
______ azszpr324573 ___
Summarizing
OraOLEDB is an OLEDB standard driver for connecting to Oracle databases.
If this message appears in your business application, the most likely is that the bank is down, falling or is too busy processing slow queries.
Long explanation
First, understand that OLEDB is an API developed by Microsoft based on the Component Object Model (COM), a model Microsoft invented to ensure interoperability between applications. This API represents a COM interface library that allows universal access to a variety of data sources, including non-SQL data sources such as Microsoft Excel, Exchange Mail Server, and Directory Services. p>
The OLEDB design focuses on the concept of consumer and provider.
Each provider implements a set of COM interface standards to handle consumer requests. A manufacturer can implement optional COM interfaces to add even more functionality to its provider.
OraOLEDB is an implementation of an OLEDB provider for Oracle database access.
See the Oracle diagram illustrating the OLEDB flow.
Moreinformationcanbefoundonthelinks.
link
___
Summarizing
OraOLEDB is an OLEDB standard driver for connecting to Oracle databases.
If this message appears in your business application, the most likely is that the bank is down, falling or is too busy processing slow queries.
Long explanation
First, understand that OLEDB is an API developed by Microsoft based on the Component Object Model (COM), a model Microsoft invented to ensure interoperability between applications. This API represents a COM interface library that allows universal access to a variety of data sources, including non-SQL data sources such as Microsoft Excel, Exchange Mail Server, and Directory Services. p>
The OLEDB design focuses on the concept of consumer and provider.
Each provider implements a set of COM interface standards to handle consumer requests. A manufacturer can implement optional COM interfaces to add even more functionality to its provider.
OraOLEDB is an implementation of an OLEDB provider for Oracle database access.
See the Oracle diagram illustrating the OLEDB flow.
Moreinformationcanbefoundonthelinks.
link
What is OraOLEDB? What is your role?
For example, there is an error here in the work system that only appears the OraOLEDB error, what are the reasons?
asked by
23.08.2018 / 21:42
1
answer
Daily Count - PL / SQL
Good morning!
In the example we have a service number, the date of entry and the date of leaving the patient; and the daily count. In the daily count I am only considering the period from 07/01/2017 to 07/31/2017, counting even the first day. Th...
asked by
07.11.2018 / 11:47
1
answer
Add and divide columns oracle
I have 4 columns. I want to do the subtraction process in 3 and divide by the fourth.
How do I do this in Oracle DB?
COLUNA1 - COLUNA2 - COLUNA3 = RESULTADO;
RESULTADO / COLUNA4 = COLUNA5
asked by
20.08.2018 / 13:46
1
answer
How to insert date and time in oracle? via c #
I'm developing a desktop application and it was working fine until the time I tried to insert the date and time generated by C # into a table in oracle. Can someone teach me the query to insert date into this format:
21/07/2018 12:54:35: (dd/m...
asked by
11.05.2018 / 16:12
2
answers
What are the differences between a PL / SQL programmer and an Oracle DBA? [closed]
Can one explain the differences between the PL / SQL programmer and the Oracle DBA ? I know there are many differences, but I'm not sure how to specify them.
I have some doubts too ...
For example:
Can a DBA program Procedures...
asked by
04.09.2017 / 16:31