kloakenratte
Grünschnabel
Hallo! Ich versuche eine procedure in Oracle zu erstellen mit einem Insert und ich erhalte 2 ERROR messages, finde jedoch nicht was ich falsch mache..
CREATE OR REPLACE PROCEDURE insert_sp
(sp_company_id IN company.company_id%TYPE,
sp_company_name IN company.company_name% TYPE,
sp_sector IN company.sector% TYPE,
sp_company_size IN company.company_size% TYPE
)
AS
BEGIN
INSERT INTO company(company_name, sector, company_size) VALUES (sp_company_name, sp_sector, sp_company_size);
EXCEPTION
* * *WHEN OTHERS THEN NULL;
END insert_sp;
/
Meine Error messages sind:
Error(7,5): PLS-00103: Encountered the symbol ";" when expecting one of the following: begin function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior external language
Error(11,2): PLS-00103: Encountered the symbol "*" when expecting one of the following: pragma when
Wäre sehr nett, wenn mir jemand helfen könnte. Danke im vorause für eure Hilfe!
CREATE OR REPLACE PROCEDURE insert_sp
(sp_company_id IN company.company_id%TYPE,
sp_company_name IN company.company_name% TYPE,
sp_sector IN company.sector% TYPE,
sp_company_size IN company.company_size% TYPE
)
AS
BEGIN
INSERT INTO company(company_name, sector, company_size) VALUES (sp_company_name, sp_sector, sp_company_size);
EXCEPTION
* * *WHEN OTHERS THEN NULL;
END insert_sp;
/
Meine Error messages sind:
Error(7,5): PLS-00103: Encountered the symbol ";" when expecting one of the following: begin function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior external language
Error(11,2): PLS-00103: Encountered the symbol "*" when expecting one of the following: pragma when
Wäre sehr nett, wenn mir jemand helfen könnte. Danke im vorause für eure Hilfe!
