Solution: PL/SQL question/puzzle

From: <kmallory_at_us.oracle.com>
Date: Fri, 10 Jul 1992 08:07:54 GMT
Message-ID: <1992Jul10.000754.1_at_us.oracle.com>

In article <1992Jul8.205544.5008_at_stortek.com>, v045100_at_otis1.stortek.com (Jennifer Farnham) writes:
> Hi, I'm converting 2.3 triggers to 3.0
> triggers in SQL*FORMS 3.0
>
> Now, i'm a wizzard at 2.3 but these 3.0
> have me wondering sometimes. Here's the
> problem:
>
> This works in Sql*Plus:
>
> select '#BETWEEN ' || '''' || :control.date1 ||
> '''' || ' and ' || '''' || :control.date2 || ''''
> into :control.long_field
> from dual
>
This can't work in SQL*Plus because you can't have bind variables in SQL*Plus.

The || operator takes character strings. Put to_char() around the control.date fields and it will compile. I was using forms 3.0.16.11 when testing this.

---

"QUALITY is never an accident; it is always the result of high intention,  sincere effort, intelligent direction and skillful execution; it represents  the wise choice of many alternatives."

Kevin Mallory                                           SQL*Forms Development
                                                        Oracle Corporation
-------------------------------------------------------------------------------

Received on Fri Jul 10 1992 - 10:07:54 CEST