in reply to Get ouput from alter package statement.

If you run that SQL-code directly through your database (Oracle?) what output do you get?

Normally "execute" is used for SELECT type of SQL-statements only and "do" is used for non-SELECT-SQL-statements.

Indeed, the "fetchrow"-instruction returns the resultset of the execute-instruction, which really only makes sense if there is a resultset to return.

The "do"-instruction returns a value, which may indicate success or failure of your SQL-statement or the number of rows on which it operated (e.g. for a DELETE or UPDATE query). See your Database documentation for more info.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

  • Comment on Re: Get ouput from alter package statement.