[sqr-users] oracle hint in sqr

["Pan, Zhen" <zhpan@indiana.edu>]

Hi,

            I am using SQR Developer 8.1. I wanted to use hint in my sqr

 

            BEGIN-SELECT distinct  

            /*+ index_join(FA_STU_TERM_STI1)*/

            A.PRSN_UNIV_ID               

            a.prsn_prm_full_nm

            A.ACAD_TERM_CD

            A.STU_NSLDS_LOAN_YR         &A.STU_NSLDS_LOAN_YR1  

            ...........

 

            when I compile it, it says

Error on line 284:

   (SQR 7740) Invalid &pseudonym or 'TYPE=' data-type specified

for a begin-select column-variable.  Valid types are:

CHAR, TEXT, DATE, NUMBER

 

      if &A.ACAD_LOAD_IND='F'

(SQR 4407) Referenced variables not defined:

 

  &a.acad_load_ind

 

            This query runs fine in Toad. I inititally thought it was
because the spaces in front of the hint, but it gave me errors too. If I
run it under Unix box it won't complain but it will run forever. (I
suspect it is not taking the hint)

            Any idea? Thanks a bunch!

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users