Page 1 of 1

How can i get the oracle's result strings?

Posted: Mon 26 Feb 2007 10:04
by ysyang
Hello Happy new year~

When i send SQL in SQL*Plus, The result string(xx rows inserted, xx rows deleted...etc) returned. As you known too.

I want to get the Oracle's result string. How can i get it?

ODAC can return it?

I'm using ODAC 5.80.0.38 for Delphi 7

Thank you

Posted: Mon 26 Feb 2007 10:22
by jfudickar
I think, this is not an common Oracle result string.

This is a sql*plus result string.

You had to create your own string.

Use the properties like rowsprocessed.

Greetings
Jens

Posted: Tue 27 Feb 2007 13:16
by Plash
ODAC does not create messages about operations that were performed. You can use the RowsAffected and RowsProcessed methods of TOraQuery to get the number of rows, that has been affected during the last operation.