Subject Re: Parameter in select statement possible?
Author patrick_marten
Hi Thomas,

> Yes, but I guess you will get an error at prepare time.
>
> You explicitely have to specify what data type the :PATH parameter is,
> e.g. with:
>
> select cast (:PATH as varchar(255)) || FILENAME as filepath from SOME_TABLE

you are right, I was getting an error regarding the data type, but somehow didn't realised what that actually meant. Now that you say it... Makes sense and works fine, thank you!