PL/SQL question/puzzle

 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

The above is the original text from the form and it worked.

However when i put it into PL/SQL:

Begin
 select (same as above)
End;

I get the following error: upon compiling, not running:

PL/SQL error 306 at line 21, column 30:
  wrong number or types of arguments in call to '||'   Sql statement ignored....

So I looked it up (the error) and it made no sense to me.

Why does the above work in 2.3 yet when the same text is in 3.0, it doesn't work?

I'm a 5 year veteran of Oracle and this one is strange to me.

Any help would be appreciated..

Thanks,
Jenny Received on Wed Jul 08 1992 - 22:55:44 CEST