>> Can anyone look at this and tell me why I receive an error (Column
> Unknown
>> V_CLT_ID) when trying to execute this procedure? V_CLT_ID is defined
> in
>> the
>> input parameters.
>>
>> FOR EXECUTE STATEMENT 'SELECT DISTINCT ATD.ACCT_TRAN_ID,
>> ATD.ACCT_TRAN_DETAIL_ID,
>> ATDT.ACCT_TASK_ID,
>> CAST(ATDT.CREATE_DATE AS
> DATE) AS
>
> Are you sure that you can pass parameters to EXECUTE STATEMENT?

You can't, the string to be executed needs to have the values inside it.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com