Re: Transform Data Task and RowCount delivered

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Have a look at these properties on the DataPump task

RowsComplete
RowsInError



"Guntram Ulrich" <ulrich@xxxxxxxxx> wrote in message news:ulrich@xxxxxxxxx:

Hi,

I have a task delivering every 15 minutes a number of lines from a database.

Is it possible to store the number of selected rows in a global variable for
further use in the package?

I don´t like to send two statements, one for the count and the next one for
the resultset because of performance problems.

Thanks for answers.

Best regards,
Guntram


.

Relevant Pages

  • remove CURSOR STATEMENT : 1 from printing out
    ... I have created a package the returns a ref cursor. ... type resultset is REF CURSOR; ... rset p_storedivreg_hist.resultset; ...
    (comp.databases.oracle.tools)
  • Re: How i know the size of "resultset"?
    ... oracle. ... i don't know resultset size,so how do i run this oracle's package and get ... but you'll need to walk trhough it to determine the ...
    (microsoft.public.dotnet.framework.adonet)
  • Getting ResultSet From Cursor Too Slow
    ... I have a method that calls an Oracle Stored Procedure from an Oracle ... Package. ... where I get the Cursor from the procedure and cast it to a ResultSet is ... Prev by Date: ...
    (comp.lang.java.databases)
  • Re: How i know the size of "resultset"?
    ... but My program is about ASP.net, i decide to use package in order to improve ... >> oracle. ... >> i don't know resultset size,so how do i run this oracle's package and ...
    (microsoft.public.dotnet.framework.adonet)