attempting to do an update procedure but getting error - PL/SQL: ORA-00933:

Question

create or replace PROCEDURE update_con
(
    c_id in       lds_consultant.consultant_id%type,
    cation in        lds_consultant.location%type,
    s_area in lds_consultant.specialist_area%type
)
IS
BEGIN
UPDATE lds_consultant 
SET 
location = cation
specialist_area =  s_area
WHERE consultant_id = c_id;
END;

Hello, I'm new to SQL and trying to create a procedure to update the specified table but for some reason it doesn't seem to work. If anyone could help it would be appreciated.

You missed comma after first column set, put comma for each column value update — Rams, May 15 '18 at 17:13

score 1 · Answer 1 · answered May 16 '18 at 06:16

You're missing a comma, between your modifiers

CREATE OR REPLACE PROCEDURE update_con (
    c_id     IN lds_consultant.consultant_id%TYPE,
    cation   IN lds_consultant.location%TYPE,
    s_area   IN lds_consultant.specialist_area%TYPE)
IS
BEGIN
    UPDATE
           lds_consultant -- Your Table
       SET
           location = cation, -- comma-seperated list of modifiers
           specialist_area = s_area
     WHERE
           consultant_id = c_id -- condition to filter rows
       ;
END;

Ora-00933 can be troubleshootet very simple. Check the row your error told you. Take the statement and check it stand-alone:

UPDATE lds_consultant
   SET location = cation, specialist_area = s_area
 WHERE consultant_id = c_id;

attempting to do an update procedure but getting error - PL/SQL: ORA-00933:

1 Answers1