4 Replies Latest reply: Mar 14, 2013 8:06 AM by fac586 RSS

    Items and SQL Types

    925144
      I've just started learning apex and I'm confused about page/application items. Since they can be used in SQL and PL/SQL as some kind of variables (for example using bind variable syntax), at some point they should be prescribed a type, since SQL and PL/SQL are both strongly typed languages.

      It seems that items do have types, see the documentation (http://docs.oracle.com/cd/E11882_01/appdev.112/e11947/bldapp.htm#BCEDCGGH), but I'm not sure how they correspond to SQL types.

      For example I saw that to_date is always used with items of date picker type, implying it is some string SQL type.

      So the question. What SQL type do apex page/application items have, that is what type conversion do I need to use when dealing with items inside SQL and PL/SQL?