PL/SQL: Using two variables in query

Question

SQL plus is giving "from keyword not found where expected". I think my query is correct select ... from ... where I think there is a possibility that we cannot use two variables in a query in PL/SQL block (I'm not sure about that).

DECLARE
  LHID   NUMBER(1);
  LNOPAT NUMBER(6);
BEGIN
  SELECT HID INTO LHID, 
         NUMPATIENTS INTO LNOPAT 
    FROM HOSPITAL065 
   WHERE HLOCATION='LAHORE';

   DBMS_OUTPUT.PUT_LINE ('HID:  ' || LHID || ' GOT PATIENTS  ' ||  
                         LNOPAT || '  LOCATED IN         LAHORE');
END;

Suggestions are welcome!

René Nyffenegger · Accepted Answer · 2014-02-24 20:23:43Z

1

You want to use one into only:

select hid, numpatients
   into lhid, lnopat
....

answered Feb 24, 2014 at 20:23

René Nyffenegger

40.9k34 gold badges180 silver badges321 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PL/SQL: Using two variables in query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related