Home » RDBMS Server » Server Administration » get no. of rows from a dynamic SQL cursor
get no. of rows from a dynamic SQL cursor [message #374956] Fri, 13 July 2001 14:31
George
Messages: 68
Registered: April 2001
Member
Does anybody can tell me how to get the number of rows affected by a dynamic SQL CURSOR? Here is my statement:

sql_statement :='SELECT * FROM '||table_name;
OPEN sum_cv FOR sql_statement;
IF sum_cv%ROWCOUNT< 10 THEN
.....

The sum_cv%ROWCOUNT is always 0.
Thanks

Report message to a moderator

Previous Topic: Re: Use of functions in Query
Next Topic: Re: sql script
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 03:52:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.