using define statement in PL/SQL developer

Question

This is one of the tasks from my homework assignement:

DEFINE countryid = CA
DECLARE 
country_record countries%ROWTYPE;
BEGIN
  SELECT *
  INTO country_record
  FROM countries
  WHERE country_id = '&countryid';
END;

According to the task requirements countryid should be declared using define statement and should be given default value CA, then select should be performed based on value entered by the user.
When I run script i get 4 errors, when I comment out DEFINE countryid = CA scripts executes successfuly.
My question: is define statement availiable in PL/SQL Developer?
If it is, what I am doing wrong and could you suggest a proper usage?

edit: I get the following errors:

ORA-06550 row 3 column 8
PLS-00201 identificator 'COUNTRY_RECORD' have to be declared
ORA-06550 row 4 column 3
PL/SQL ORA-00904: invalid identificator
ORA-06550 row 2 column 3
PL/SQL SQL statement ignored

Does it have to be PL/SQL-Developer? Could you use SQL*PLUS instead? — Erich Kitzmueller
– Erich Kitzmueller, Commented Nov 29, 2012 at 12:21
DEFINE is really the sort of thing that is used as part of a code deployment or installation, and those should always be executed through SQL*Plus. — David Aldridge
– David Aldridge, Commented Nov 29, 2012 at 12:30
No there aren`t any constraints on development environment. I asked about PL/SQL-Devaloper because I work with it at home and on our practice at the university we use SQLplus — spin_eight
– spin_eight, Commented Nov 29, 2012 at 12:32

DazzaL · Accepted Answer · 2012-11-29 12:22:14Z

9

DEFINE is a SQLPLUS thing, and as such isn't supported in PLSQL Developer apart from in the COMMAND window. for the sql / test window, just remove it (it will see the & and give you a popup for you to define it that way).

answered Nov 29, 2012 at 12:22

DazzaL

22.1k3 gold badges52 silver badges57 bronze badges

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

Comments

Isha · Accepted Answer · 2012-11-29 19:31:43Z

0

in PLSQL Developer, you can use this code, But use the Command Window.

DEFINE countryid = 'CA' DECLARE country_record countries%ROWTYPE; BEGIN SELECT * INTO country_record FROM countries WHERE country_id = '&countryid'; END;

answered Nov 29, 2012 at 19:31

Isha

311 bronze badge

Comments

David · Accepted Answer · 2016-11-17 17:14:27Z

0

DEFINE countryid = CA
DECLARE 
country_record countries%ROWTYPE;
BEGIN
  SELECT *
  INTO country_record
  FROM countries
  WHERE country_id = :countryid;
END;

edited Nov 17, 2016 at 17:14

David

11.6k4 gold badges44 silver badges46 bronze badges

answered Nov 17, 2016 at 17:01

mlulis

1

Collectives™ on Stack Overflow

using define statement in PL/SQL developer

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related