Geek Answers Handbook

How to register raw SQL from Oracle occi C ++ api?

One of our customers complains that our application is not working. Their argument is that our sql function function for their Oracle database does not get the expected result. Sometime this should fail, but our application got success from its database. This is really frustrating because it is their database and we cannot do any tests on it.

We use the OCCI Oracle C ++ API. Anyway, can we write raw sql from our end? This will be very useful, and we can send the script to them and let them debug on our system to find out the problem.

Thanks in advance.

+5
source share
3 answers

I assume that you only issue the SQL statement, since you are saying that you want to see "source SQL from your end." It is best then to get the database trace as suggested.

I want to note that even if your SQL returns the expected result in the test database, the same SQL may return an unexpected result in another database, because the data may be different: the data may be damaged, indexes may exist or may not exist, restrictions may be defined or not, etc. Definitely, you need to get trace from the database in order to be able to move forward.

+1
source

, , , .

SQL, .

( , , SQL-), :

http://www.symantec.com/connect/articles/detecting-sql-injection-oracle

, . Oracle Fine Grained Auditing - , Oracle 9i .

0

, , SQL-. , , SQL . , , .. .

SQL

DBMS_MONITOR

0

More articles:


All Articles