This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Mar 28, 2013 1:10 PM by Howard (... in Training) Go to original post RSS
  • 15. Re: Query works in sqldeveloper but not apex
    fac586 Guru
    Currently Being Moderated
    tfa wrote:
    I believe bind variables are case sensitive. In your new page is the following bind variable capitalized in your query?
    Your belief is incorrect. APEX bind variables—like SQL and PL/SQL in general—are case insensitive.

    Some things elsewhere in APEX are case sensitive, which in my view is a serious error on Oracle's part given the expectations of experienced PL/SQL developers.
  • 16. Re: Query works in sqldeveloper but not apex
    Howard (... in Training) Pro
    Currently Being Moderated
    >
    If I run this query in sqldeveloper it returns a correct result

    select * from t3_mail_piece
    where '111-000-461' BETWEEN start_merge_code and end_merge_code;

    RESULT
    302 Travel_Check American_TAD_Typed_Template 22-APR-13 30-APR-13 555-2424 Scottsdale 1 1350 111-000-461 111-000-465 17 1 One Thousand Three Hundred Fifty and 00/100
    >
    You have my compete sympathy. This happens to folks ALL THE TIME. Code runs differently in SQL Developer than it does in APEX -- but for a good reason. They are different.

    You should run the code in the APEX > SQL Workshop > SQL Commands window. Then tell us what you see? You will have to enter a value for the bind variable -- don't hardcode the bind variable. It must be the problem.

    Howard
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points