How can i get the oracle's result strings?

ysyang · Post by **ysyang** » Mon 26 Feb 2007 10:04

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

jfudickar · Post by **jfudickar** » Mon 26 Feb 2007 10:22

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

Plash · Post by **Plash** » Tue 27 Feb 2007 13:16

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.