Here are some easy ways that can help fix Oracle error pls 00103.
PC running slow?
PLS-00103: ‘END’ character encountered when one of the following was expected: An error occurs after the ‘END’ keyword is found when PL/SQL code is expected and has a valid literal value. When Oracle scans PL/SQL code but compiles it, it recognizes the “END” flag instead of a literal flag.
Not The Explanation You’re Looking For? Browse Other Queries Tagged Plsql Oracle Stored Procedures Sql Or Just Ask Your Own Question.
When expecting one of the following := the symbol := was substituted for?
1/107 PLS-00103: Symbol “(” is displayed when displaying one of the following elements: := . ), @ % default layout Symbol “:=” changed to “(” to continue. However parameters do not have length . arg_verify_mode must feel like varchar 2. Also, you can’t declare it in stored procedures.
CREATE OR REPLACE PROCEDURE procedure name( <
> )LIKE < >BEGIN <
>END procedure name;
- You have added
BEGINbefore many declarations
- You have an irrelevant
DECLARE– a person will only use it when users declare a PL/SQL block, most of which don’t include
- You omit the semicolon after the
- An approach cannot have a return value. If you want to go back to 1 or 0, you probably want functionality, not therapy. If you need a processing plan, you can declareparameter
- You missed
CREATE OR REPLACE LIST_ACTIONS_CHECK_ADD FUNCTION( LIST NAME IN VARCHAR2) RETURN NUMBERLIKE SNT NUMBER;BEGIN SELECT QUANTITY(LIST_NAME). At UNT FROM LISTEN_MASTER WHERE LIST_NAME implies LISTNAME; IF (CHNT > 0) THEN RETURN 1; DIFFERENT RETURN 0; END IF;END OF LIST_ACTIONS_CHECK_ADD;
Note that, as a big general difference, it’s usually better to use some sort of naming convention to ensure that local variable parameters and sizes don’t have a common name that refers to a column. Trying to figure out whether
LISTNAME is a function parameter or a column name, and what is the difference between
LISTNAME, usually confuses future developers. I personally use the correct
p_ prefix for parameters and the large
l_ prefix for local variables. I would also suggest using the bound types
lists_master --.list_name%type if passed
What is set Serveroutput on?
Essentially, the use of SET SERVEROUTPUT is to display a query alternative in the *PLUS SQL interface when one uses DBMS_OUTPUT. PUT_LINE Our procedure writes the transfer area to the oracle buffer. Use Set serveroutput on to illustrate the buffer used by dbms_output.
CREATE OR REPLACE LIST_ACTIONS_CHECK_ADD FUNCTION( P_LIST_NAME In listmaster.listname%type) RETURNNUMBERLIKE L_CNT-NUMBER;BEGIN SELECT QUANTITY(LIST_NAME). In L_CNT FROM LISTEN_MASTER WHERE LIST_NAME means P_LIST_NAME; IF (L_CNT > 0) THEN RETURN 1; DIFFERENT RETURN 0; END IF;END OF LIST_ACTIONS_CHECK_ADD;
answered December 6, 2012 at 4:34 pm.
How do I fix error pls-00103?
There is usually no simple solution for any type of error. The only possible direct answer would be to point out that the previous query is started with a semicolon. For some reason the PL/SQL compiler ran into a “choice” whenhe didn’t know he was still supposed to be there.