Anonymous procedure PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := ( ; not null range default character

Question

here's the code:

http://sqlfiddle.com/#!4/ee7da/4247


CREATE TABLE supportContacts 
(
 id int primary key, 
 type varchar2(20), 
 details varchar2(40)
)
/

INSERT INTO supportContacts
(id, type, details)
VALUES
(1, 'Email', 'admin@sqlfiddle.com')

/

INSERT INTO supportContacts
(id, type, details)
VALUES
(2, 'Twitter', '@sqlfiddle')


DECLARE
 x supportContacts.type%type;
 y supportContacs.details%type;
BEGIN 
  select type,details into x,y from supportContacts where id = 1;
  dbms_output.put_line(x);
  dbms_output.put_line(y);
END; 
/

i wonder why this doesn't work?

score 3 · Answer 1 · answered Mar 25 '13 at 03:17

3

This: y supportContacs.details%type;

Should be: y supportContacts.details%type;

If I make that change, it works for me.

answered Mar 25 '13 at 03:17

DCookie

42,630
11
83
92

ah okay, my bad XD do you know if sqlfiddle can output put_line – Kokizzu Mar 25 '13 at 03:22
1

Don't know, never used it. Can you do "set serveroutput on"? – DCookie Mar 25 '13 at 03:34
1

Then I would say it probably isn't supported. You should build another table to send your "output" to and select from it to see your results. – DCookie Mar 25 '13 at 13:16

score 1 · Accepted Answer · answered Mar 25 '13 at 08:56

1

You need change query terminator symbol with bottom right button (like combobox); See proof SQLFiddle

answered Mar 25 '13 at 08:56

knagaev

2,897
16
20

Anonymous procedure PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := ( ; not null range default character

2 Answers2