00103 Error In Pl Sql
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn raise error pl sql more about Stack Overflow the company Business Learn more about hiring developers or posting what is mutating error in pl sql ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack ora-06550 error in pl sql Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up pl sql error PLS-00103 up vote 0 down vote favorite I
Raise Error T Sql
have a table(customer) and is has attributes of c_Id, fname, lname, age the table is populated with the following values 1|Ann|Smiths|23 2|Chris|Gates|21 3|Janes|Jobs|24 I am very new to pl/sql and I wrote a simple select statement DECLEAR name varchar2(50); BEGIN SELECT fname into name FROM customer WHERE fname= 'Ann'; END; When I execute the script my from my textfile(doselect) on sqlplus using the following command EXECUTE doselect however raise error transact sql it gives me the following error ERROR at line 1: ORA-06550: line 1, column 8: PLS-00103: Encountered the symbol ":" when expecting one of the following: := . ( @ % ; Please help. plsql sqlplus share|improve this question asked Feb 28 '14 at 14:01 user3213758 4819 You've got a typo in your PLSQL script - it should be DECLARE instead of DECLEAR. –Frank Schmitt Feb 28 '14 at 14:06 still having the same error despite changing it to DECLARE –user3213758 Feb 28 '14 at 14:08 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted Apart from the typo (DECLEAR instead of DECLARE), your script looks fine. To get output from SQL/Plus, I'd also add a DBMS_OUTPUT statement: DECLARE name varchar2(50); BEGIN SELECT fname into name FROM customer WHERE fname= 'Ann'; -- print it dbms_output.put_line(name); END; However, to execute a file from SQL/Plus, don't use the EXECUTE command - rather use @ : SQL> set serveroutput on SQL> @doselect 10 / Ann SQL/Plus is not very friendly to new users - you might want to use another client to get started (e.g. Oracle SQL/Developer - it's free and comes with a nice GUI). share|improve
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us oracle pls-00103 encountered the symbol when expecting one of the following Learn more about Stack Overflow the company Business Learn more about hiring developers
Oracle Pls-00103 Encountered The Symbol End-of-file
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Pls 00103 Oracle Error
Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up PL/SQL Function Error - PLS-00103: Encountered the symbol http://stackoverflow.com/questions/22097244/pl-sql-error-pls-00103 “IS” up vote 1 down vote favorite I am trying to create a simple PL/SQL function but its returning error -> PLS-00103: Encountered the symbol "IS". I am not sure whats wrong here, so could anybody out there please help. I followed the following steps - Step1 - Logged in as sysdba using - sqlplus / as sysdba Step2 - Created a file name test.sql with following http://stackoverflow.com/questions/13216228/pl-sql-function-error-pls-00103-encountered-the-symbol-is code under C:\ - CREATE OR REPLACE FUNCTION employer_details_func RETURN VARCHAR(20); IS emp_name VARCHAR(20); BEGIN SELECT first_name INTO emp_name FROM emp_tbl WHERE empID = '100'; RETURN emp_name; END; / Step3 - Ran the following commands - SQL>@C:\test.sql Warning: Function created with compilation errors. SQL> show error function Func; Errors for FUNCTION FUNC: LINE/COL ERROR 5/1 PLS-00103: Encountered the symbol "IS" SQL> Don't know why am I getting this weird error. Any help is highly appreciated. function plsql compiler-errors share|improve this question asked Nov 4 '12 at 5:07 anujin 25041532 1 When you login AS SYSDBA you connect to the SYS account. Please please please do not do this. SYS is a very powerful account because it owns the data dictionary. Consequently it is very easy to corrupt the database working as SYS if we don't understand what we;re doing. No offense, but the tenor of your question (a trivial syntax error) suggests this is your situation. Use SYS to create an application user, then use that to create schema objects. –APC Nov 4 '12 at 13:59 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote Create your function as follows and try
symbol "CREATE" [message #115856] Thu, 14 April 2005 13:48 m_scandroglio Messages: 26Registered: March 2005 Junior Member Hi all! I have a problem: alter trigger CAN_CHIAVE compile; http://www.orafaq.com/forum/t/44139/0 Warning: Trigger altered with compilation errors. SQL> show error Errors for TRIGGER CAN_CHIAVE: LINE/COL ERROR -------- ----------------------------------------------------------------- 14/1 PLS-00103: Encountered the symbol "CREATE" The trigger syntax is correct 'cause http://oracle.ittoolbox.com/groups/technical-functional/oracle-sql-l/plsql-package-error-pls00103-endoffile-5290588 the same script to create it has been launched on other 3 schema identical!!! any idea???? thanks! Report message to a moderator Re: PLS-00103: Encountered the pl sql symbol "CREATE" [message #115874 is a reply to message #115856] Thu, 14 April 2005 14:55 smartin Messages: 1803Registered: March 2005 Location: Jacksonville, Florida Senior Member Care to post the syntax? Report message to a moderator Re: PLS-00103: Encountered the symbol "CREATE" [message #115916 is a reply to message #115874] Fri, 15 April 2005 04:32 m_scandroglio Messages: error in pl 26Registered: March 2005 Junior Member CREATE OR REPLACE TRIGGER CAN_CHIAVE AFTER UPDATE OF D_FINE_VALIDITA ON CHIAVI FOR EACH ROW BEGIN IF DBMS_REPUTIL.FROM_REMOTE = FALSE THEN UPDATE SET_CHIAVI SET Q_CHIAVI_DISPONIBILI = Q_CHIAVI_DISPONIBILI - 1 WHERE K_ID_SET = :new.E_ID_SET AND Q_CHIAVI_DISPONIBILI > 0; END IF; END; any suggestions? I can't understand why on the others db there's not problem!! Report message to a moderator Re: PLS-00103: Encountered the symbol "CREATE" [message #116002 is a reply to message #115916] Fri, 15 April 2005 18:14 Barbara Boehmer Messages: 8589Registered: November 2002 Location: California, USA Senior Member Something must be different. I find it curious that your error message says that it is finding "CREATE" on line 14, but there is no "CREATE" on line 14 of the code that you posted. What does the following produce? break on owner column text format a45 word_wrapped select owner, text from all_source where name = 'CAN_CHIAVE' order by owner, line / Report message to a moderator Re: PLS-00103: Encountered the symbol "CREATE" [message #116044 i
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Ramnath.Awate Dennis Stevenson Craig Borysowich Nikki Klein AbhaiTripathi bluesguyAZ59 iudithm knowscognosdoi Clinton Jones mircea_luca Iqbalyk COMPANIES VAI SendGrid Apperian Panaya Inc. View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle T-SQL For discussion on Oracle T-SQL , please visit the Oracle Applications group. More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Pl/SQL Package Error PLS-00103: 'End-of-File' sarathr asked Aug 19, 2013 | Replies (3) When I am compiling below script it is showing END-OF-FILE error CREATE OR REPLACE PACKAGE BODY make_flow_item_pkg IS PROCEDURE make_flow(p_inv_item_id IN NUMBER) IS --v_cat_set_id NUMBER; cnt NUMBER:=0; v_inv_item_id NUMBER; v_qct_dem_cat_id NUMBER; v_qc_inv_cat VARCHAR2(30); v_cat_assign VARCHAR2(30); v_qct_hard_type VARCHAR2(30); v_item_commodity_code VARCHAR2(30); v_item VARCHAR2(30); BEGIN BEGIN SELECT SEGMENT1 INTO v_item FROM MTL_SYSTEM_ITEMS_B WHERE INVENTORY_ITEM_ID=p_inv_item_id; SELECT count(*) INTO cnt FROM WF_ITEMS WHERE ITEM_TYPE ='LAAFSETH' --and item_key like '%RL90%NC155%38D%' AND USER_KEY LIKE v_item||'%QC%OM%Flow'; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.put_line('no data found'); END; IF cnt > 0 THEN begin SELECT 'X' FROM MTL_ITEM_CATEGORIES_V WHERE ORGANIZATION_ID IN ('225','226','227') AND INVENTORY_ITEM_ID=p_inv_item_id AND CATEGORY_SET_NAME = 'QC QCT DEMAND CATEGORY'; IF v_cat_assign='X' Then BEGIN SELECT SEGEMENT1,S