This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 188198 - Cannot execute whole CREATE PROCEDURE command
Summary: Cannot execute whole CREATE PROCEDURE command
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-29 13:53 UTC by Jiri Rechtacek
Modified: 2010-08-31 10:38 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jiri Rechtacek 2010-06-29 13:53:29 UTC
Execute this SQL editor.
========================
create or replace
PROCEDURE add_job_history2
  (  p_emp_id          job_history.employee_id%type
   , p_start_date      job_history.start_date%type
   , p_end_date        job_history.end_date%type
   , p_job_id          job_history.job_id%type
   , p_department_id   job_history.department_id%type
   )
IS
BEGIN
  INSERT INTO job_history (employee_id, start_date, end_date,
                           job_id, department_id)
    VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;
=====================
It gives output:
Executed successfully in 0.293 s, 0 rows affected.
Line 1, column 1

Error code 900, SQL state 42000: ORA-00900: invalid SQL statement

Line 14, column 1

Execution finished after 0.293 s, 1 error(s) occurred.

The problem is SQL executer split this to two commands divided by ';' what is wrong in this case.
Comment 1 Jiri Rechtacek 2010-08-31 10:38:03 UTC
Solved in NB6.10M2, Oracle, MySQL procedures allow to edit their source code.