On 23 Feb 2006 10:54:59 -0800, "dean" <deanbrown3d@xxxxxxxxx> wrote:
I'm running some debug code in a program in C++, and I have a grid that
returns the results of any SQL statement that I care to enter on
screen. I can see the results of a select query, or I can execute a
command (such as delete), but in the latter case I can't see any
responce from Oracle to tell me what happened in the command (for
example, that 10 rows were deleted). How can I get this last message
back from Oracle?
Thanks!
Dean
Both Pro*C and OCI automagically return the number of rows affected.
As you don't specify which Oracle supplied API you are using your
question can't be answered.
Re: monitorring number of records processed by AS ...execute an MDX query which return this measure and compare to the expected ... Have you take a look at the query executed by AS against your oracle ... Data source is ORACLE....Data provider is ORACLE PROVIDER for OLEDB. ... (microsoft.public.sqlserver.olap)
oldie but still a baddie (ADO [NOT .net], Oracle) ... need to use an ADO Command and Parameters object to call an Oracle...Dim Command As New ADODB.Command ...Optional Connection As ADODB.Connection, _ ... 'Set up as a text command just to execute SQL... (microsoft.public.data.ado)
SUMMARY: sudo version 1.6.7p5 : using -H -u options on Solaris 8 ... Many thanks to those that responded, as expected all responses were helpful. ... This will allow you to do the thing that the user oracle requires while also ... designated in the sudoers file who requires to use the command,... there is a CLASSPATH variable set which, as the oracle user I can see by ... (SunManagers)
Re: Basic question | run multiple queries without reconnecting ... :>From an oracle client like oracle sqldeveloper, I can run the DCL - ... : system as role: sysdba - but then I cant even connect to the db.. ... as default - I get the same error when I run this command:... (comp.databases.oracle.server)
