Subject | Re: Parameter in select statement possible? |
---|---|
Author | patrick_marten |
Post date | 2012-11-23T14:36:24Z |
Hi Thomas,
> Yes, but I guess you will get an error at prepare time.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!
>
> 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