OraFAQ Forum: SQL & PL/SQL » PLS-00103 Error is driving me crazy

Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00103 Error is driving me crazy

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PLS-00103 Error is driving me crazy [message #39728]

Mon, 05 August 2002 14:16

Paola
Messages: 2
Registered: August 2002

Junior Member

CREATE OR REPLACE procedure SPI_T_VACANCIES(p_vacancytext varchar2, p_status integer,p_adminid integer)
IS
BEGIN
begin
INSERT INTO T_VACANCIES (VACANCYID,VACANCY_TEXT,STATUS,USERADMINID)
VALUES(q_vacancyId.nextval,p_vacancytext,p_status,p_adminid);
commit;
end;
END SPI_T_VACANCIES;

This procedure runs perfectly in my test server, however, when i try to move it for real, it gives me the following error:

PLS-00103: Encountered the symbol "" when expecting one of the following: ; is with authid deterministic parallel_enable as

Any ideas as which might be the problem??

Thanks in advance

Report message to a moderator

Re: PLS-00103 Error is driving me crazy [message #39729 is a reply to message #39728]

Mon, 05 August 2002 14:45

Silpa
Messages: 23
Registered: July 2002

Junior Member

Try putting "" in front of the column names. I had similar type of problem before when i tried putting quotes it went off.

CREATE OR REPLACE procedure SPI_T_VACANCIES(p_vacancytext varchar2, p_status integer,p_adminid integer)
IS
BEGIN
begin
INSERT INTO T_VACANCIES ("VACANCYID","VACANCY_TEXT","STATUS","USERADMINID")
VALUES(q_vacancyId.nextval,p_vacancytext,p_status,p_adminid);
commit;
end;
END "SPI_T_VACANCIES";

Report message to a moderator

Previous Topic:	How to query/change DB's NLS_LANG and D2000's NLS_LANG?
Next Topic:	Create Session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 10:07:52 CDT 2024