Programming Forums > Application Development > Other Programming Languages

A.K.Al Shamsi · May 7th, 2008, 12:09 PM

hi guys

how are you??

i am coding for project and i got errors but i don't know what is the wrong??

here is the code

set serveroutput on

declare 
h00019852_depid :=departments.department_id%type;

begin
select max(h00019852_depid) into department_id
from departments
group by department_id;

dbms_output.put_line('The maximum department id is: '||h00019852_depid);
end;

this is the error:
(h00019852_depid :=departments.department_id%type;
*

ERROR at line 2:
ORA-06550: line 2, column 17:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue. )

==========================================================

and this too

(Toggle Plain Text)

set serveroutput on
accept h00019852_depid prompt'Enter department id:'

declare
h00019852_depid Number:= employees.department_id%type;
h00019852_empid employees.employee_id%type;

begin 
select (count(h00019852_empid)) into  employee_id
from employees
where departments.department_id=employees.department_id;

dbms_output.put_line(h00019852_empid||'employee(s) work for department number'||depid);

end;

and this is the error for code

(h00019852_depid Number:= employees.department_id%type;
*

ERROR at line 2:
ORA-06550: line 2, column 50:
PLS-00208: identifier 'TYPE' is not a legal cursor attribute
ORA-06550: line 2, column 17:
PL/SQL: Item ignored
ORA-06550: line 8, column 7:
PL/SQL: ORA-00904: "DEPARTMENTS"."DEPARTMENT_ID": invalid identifier
ORA-06550: line 6, column 1:
PL/SQL: SQL Statement ignored
ORA-06550: line 10, column 81:
PLS-00201: identifier 'DEPID' must be declared
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored )

could you help me, please?!

May 7th, 2008, 12:09 PM	#1
A.K.Al Shamsi Programmer Join Date: Mar 2008 Posts: 35 Rep Power: 0	Pl/sql hi guys how are you?? i am coding for project and i got errors but i don't know what is the wrong?? here is the code (Toggle Plain Text) set serveroutput on declare h00019852_depid :=departments.department_id%type; begin select max(h00019852_depid) into department_id from departments group by department_id; dbms_output.put_line('The maximum department id is: '\|\|h00019852_depid); end; set serveroutput on declare h00019852_depid :=departments.department_id%type; begin select max(h00019852_depid) into department_id from departments group by department_id; dbms_output.put_line('The maximum department id is: '\|\|h00019852_depid); end; this is the error: (h00019852_depid :=departments.department_id%type; * ERROR at line 2: ORA-06550: line 2, column 17: PLS-00103: Encountered the symbol "=" when expecting one of the following: constant exception <an identifier> <a double-quoted delimited-identifier> table LONG_ double ref char time timestamp interval date binary national character nchar The symbol "<an identifier>" was substituted for "=" to continue. ) ========================================================== and this too (Toggle Plain Text) set serveroutput on accept h00019852_depid prompt'Enter department id:' declare h00019852_depid Number:= employees.department_id%type; h00019852_empid employees.employee_id%type; begin select (count(h00019852_empid)) into employee_id from employees where departments.department_id=employees.department_id; dbms_output.put_line(h00019852_empid\|\|'employee(s) work for department number'\|\|depid); end; set serveroutput on accept h00019852_depid prompt'Enter department id:' declare h00019852_depid Number:= employees.department_id%type; h00019852_empid employees.employee_id%type; begin select (count(h00019852_empid)) into employee_id from employees where departments.department_id=employees.department_id; dbms_output.put_line(h00019852_empid\|\|'employee(s) work for department number'\|\|depid); end; and this is the error for code (h00019852_depid Number:= employees.department_id%type; * ERROR at line 2: ORA-06550: line 2, column 50: PLS-00208: identifier 'TYPE' is not a legal cursor attribute ORA-06550: line 2, column 17: PL/SQL: Item ignored ORA-06550: line 8, column 7: PL/SQL: ORA-00904: "DEPARTMENTS"."DEPARTMENT_ID": invalid identifier ORA-06550: line 6, column 1: PL/SQL: SQL Statement ignored ORA-06550: line 10, column 81: PLS-00201: identifier 'DEPID' must be declared ORA-06550: line 10, column 1: PL/SQL: Statement ignored ) could you help me, please?!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PL/SQL - get DB name	Gumby	Other Programming Languages	7	Jun 1st, 2006 10:08 AM
PL/SQL code question	java_roshan	Other Programming Languages	5	Oct 12th, 2005 2:25 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Other Programming Languages

Pl/sql