Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    8

    Unanswered: re: is this coding got errors?

    dear all,

    hi! i m trying to create 2 inputs for user to enter in order to fit into my sql statement. i can manage to create one user input, but come to 2 inputs error occurs. they just prompt out one input request instead of two. should i put any delimeter to separate the two user input parameters. i really got no idea..thanks!

    below is the coding with 2 input p_divfr and p_divto

    SELECT ALL SBCLSMST.SUBCLASS, SBCLSMST.SUBCLASS_DESC, CLASSMST.CLASS, CLASSMST.CLASS_DESC,
    DIVMST.DIV AS F_DIV, DIVMST.DIV_NAME, DEPTMST.DEPT, DEPTMST.DEPT_NAME
    FROM DIVMST, DEPTMST, CLASSMST, SBCLSMST
    WHERE ((DEPTMST.DEPT_DIV = DIVMST.DIV)
    AND (CLASSMST.CLASS_DEPT = DEPTMST.DEPT)
    AND (SBCLSMST.SUBCLASS_CLASS = CLASSMST.CLASS))
    AND TO_CHAR(DIVMST.DIV) LIKE: P_DIVFR
    AND TO_CHAR(DIVMST.DIV) LIKE: P_DIVTO
    AND DIVMST.DIV BETWEEN P_DIVFR AND P_DIVTO;



    regards,
    jason

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >come to 2 inputs error occurs.
    Error? What error?
    I don't see any error.

    >i really got no idea..
    Neither does anybody else because we are not mind readers.
    What information of substance have you provided?
    Answer - NONE!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Posts
    8
    dear all,


    sorry for not giving the error message...
    below is the error message that appear when using the above sql statemet...

    ORA-00904:invalid column name


    thanks!



    regards,
    jason

  4. #4
    Join Date
    Dec 2003
    Posts
    8
    sorry missed out something...this the


    ORA-00904:invalid column name
    AND DIVMST.DIV BETWEEN P_DIVFR AND ==>P_DIVTO




    thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •