PLS-00103 / Encountered Symbol NUMBER When Expecting One Of Following

Jun 7, 2011

I am getting the below error while trying to schedule a simple dbms_job.

JOB:
=====
declare
VARIABLE v_jobnum NUMBER;
begin
DBMS_JOB.SUBMIT(job => v_jobnum,
what => 'dbms_refresh.refresh(""SCHEMA"."MyMaterializedView"");',
next_date => to_date("05-07-2011 13:45","DD-MM-YYYY HH24:MI"),
interval => '(ADD_MONTHS(TRUNC(SYSDATE,"MM")+4,1)+13.75/24)');
end;
/

ERROR:
======
LINE TEXT
2 ORA-06550: line 2, column 19:
1 PLS-00103: Encountered the symbol "NUMBER" when expecting one of the following:
1 := . ( @ % ; not null range default character
1 The symbol ":=" was substituted for "NUMBER" to continue.

View 2 Replies


ADVERTISEMENT

SQL & PL/SQL :: PLS-00103 - Encountered Symbol NUMBER

Jun 7, 2011

I am trying to schedule a DBMA_JOB and getting the below mentioned error.

JOB:
====

declare
VARIABLE v_jobnum NUMBER;
begin
DBMS_JOB.SUBMIT(job => v_jobnum,
what => 'dbms_refresh.refresh(""CLARITY"."M_MV_INBASKET_ANALYSIS"");',
next_date => to_date("05-07-2011 13:45","DD-MM-YYYY HH24:MI"),
interval => '(ADD_MONTHS(TRUNC(SYSDATE,"MM")+4,1)+13.75/24)');
end;
[code]....

View 20 Replies View Related

PLS-00103 / Encountered The Symbol (end-of-file)

May 18, 2010

when creating this,

create or replace package body test as

employees emp_tab := emp_tab();
procedure test1 as
g_ref sys_REFCURSOR;
BEGIN
employees.EXTEND(2);
employees(1) := emp_type (1, 'name1');
employees(2) := emp_type (2, 'name2');
OPEN g_ref FOR
SELECT * FROM TABLE (CAST (employees AS emp_tab));
END test1;

I got a error ERROR at line 11: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

begin end function package pragma procedure form

1. create or replace package body test as
2. employees emp_tab := emp_tab();
3. procedure test1 as

View 1 Replies View Related

SQL & PL/SQL :: Encountered The Symbol End-of-file?

May 27, 2011

i am getting error for this code

CREATE OR REPLACE FUNCTION "ABS"."PROCESS_YEAR"(processYear DATE) RETURN NUMBER DETERMINISTIC IS
year NUMBER:=NULL

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_

View 3 Replies View Related

How To Change Decimal Symbol And Digit Grouping Symbol

Jun 19, 2011

Currently , my system using , as digit grouping symbol and . as decimal symbol in Oracle forms and report. Is there any way to reverse that to the whole system?

View 3 Replies View Related

SQL & PL/SQL :: Getting Expecting External Language Error When Compiling Package

Sep 27, 2013

It's been some time since I've written any PL/SQL, I'm getting Found 'CURSOR' Expecting: External Language for line 76 when I try to compile? :

1 create or replace PACKAGE pa_user_maint
2 AS
3
4
5 -- ------------------------------------------------------------------------------------
6 -- Exceptions
7 -- ------------------------------------------------------------------------------------
8
9 -- User Exists
10
11 ex_existingUser exception;
12 PRAGMA EXCEPTION_INIT (ex_existingUser, -01920);
13
[code].......

View 1 Replies View Related

SQL & PL/SQL :: PLS-00103 Error Within Function

May 11, 2011

I'm receiving these errors when I try to run my function. The object of my function is to "This function will format the employee's name in the following format:

if the employee has a middle initial: John P. Smith
If the employee does not have a middle initial: John Smith"

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/1 PLS-00103: Encountered the symbol "P_INITIAL" when expecting one
of the following:
:= ) , default character
The symbol "," was substituted for "P_INITIAL" to continue.

4/1 PLS-00103: Encountered the symbol "P_LNAME" when expecting one of
the following:
:= ) , default character
The symbol "," was substituted for "P_LNAME" to continue.
[code]....

And that is the syntax I currently have.

View 6 Replies View Related

SQL & PL/SQL :: (error) PLS-00103 / Creating Package

Jul 19, 2012

When trying to create package I receive this error...[Error] PLS-00103 (8: 16): PLS-00103: Encountered the symbol "." when expecting one of the following:;

pointing to "." in the last line "END nondrg_prod.Readmissions;"

CREATE or replace PACKAGE nondrg_prod.Readmissions AS
TYPE Readmits IS REF CURSOR RETURN READMISSIONS_DATA_MH%ROWTYPE;
PROCEDURE open_rdmh (rdmh IN OUT rdmhCurTyp);
END Readmissions;

[code]....

View 14 Replies View Related

ORA-07445 - Exception Encountered?

May 9, 2011

Am getting the error ORA-03113: end-of-file on communication channel when am trying to run a query and when i checked the trace file the infromation i got is given below.....

CODEksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x363376E] [] [] [] []
Current SQL statement for this session:
select
count(av_sal)

[code]...

View 1 Replies View Related

ORA-01731 Circular View Definition Encountered

Feb 22, 2013

I created a view for emp1 table.

SQL> select   view_name , text   from  dba_views  where VIEW_NAME='EMP1_VIEW';          

VIEW_NAME      TEXT

EMP1_VEW       select  empid , ename , qual,  dept  from  emp1
where  empid  between  1000 and  1010

Now  i tried to  use create or replace option

SQL>create or replace  view emp1_view as
*2 select * from emp1_view with read only;*
create or replace  view emp1_view as
*+
ERROR at line 1:
ORA-01731: circular view definition encountered

Actually i want to make read only  view (emp1_view) ;  without  doping  ;

View 16 Replies View Related

ORA-1403 Encountered When Generating Server Alert?

Jun 7, 2012

how to resolve the below error.. I am getting this error on the alert log .. oracle DB version is 11.2.0.1 and os is AIX6.1

ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:38:27 2012
ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:39:00 2012
ORA-1403 encountered when generating server alert SMG-3503 Thu Jun 07 13:43:27 2012
ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:48:27 2012

View 4 Replies View Related

Trace File - MVs Failed (ORA-10980 Error Encountered)

Oct 19, 2010

In Trace file I am always geeting one error "Error encountered: ORA-10980" due to which MVs fails . how to overcome from this error?

View 2 Replies View Related

Server Utilities :: EXP-00008 / ORACLE Error 933 Encountered

Feb 27, 2012

every day we have full backup of oracle database (9.2.0.1.0) on windows 2003 server. since couple of days i am getting following below error. i checked the solutions on google which talk about user quotas , i checked the user quotas by which i am taking full backup it is unlimited , even i tried another user which also have umlimited quota on its default tablespace still i getting below

E:ackup>exp system/manager file=full26022012.dmp log=full26022012.log full=y statistics=none
EXP-00008: ORACLE error 933 encountered
ORA-00933: SQL command not properly ended
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp

even i go for full export by any other user which has full export privilege & unlimited quotas. i getting the same error.

E:ackup>exp username/password file=full26022012.dmp log=full26022012.log full=y statistics=none
EXP-00008: ORACLE error 933 encountered
ORA-00933: SQL command not properly ended
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp

View 4 Replies View Related

SQL & PL/SQL :: KUP-00554 / Error Encountered While Parsing Access Parameters

Jun 25, 2012

I am trying to create an EXT table but is constantly having the following problem, not sure why. I have done a few checks and used the scripts used as a standard but still is experiencing an error.

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "minussign": expecting one of: "double-quoted-string, identifier, single-quoted-string"
KUP-01007: at line 9 column 1

The Table creation script is

CREATE TABLE TABLE1_EXT
(
BUSINESS_DATE VARCHAR2(50 BYTE),
CIN_CODE VARCHAR2(50 BYTE),
CIS_CODE VARCHAR2(50 BYTE)
)

[code]....

And the data used as a sample is

BusinessDate|CIN|CISCode
19062012|1000026697|CTTGLIE
19062012|1000079416|Z29MBGB

View 12 Replies View Related

Networking And Gateways :: ORACLE Error 12154 Encountered - Could Not Resolve Service Name

May 13, 2013

I have overwritten tnsnames.ora file with newone. In new tnsnames.ora file I have added new host string, remaining all unchanged.

after that, when trying to connect using sqlplus(from windows machine, sqlplusw.exe), working fine. But when trying to connect through putty getting error.

ORA-12154: TNS:could not resolve service name

for the same reason my scheduled cron tab can not run export backup. cron tab error is

EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully

I am suspecting problem may be due to file accessing permission related issue. But cant solve it. Current tnsnames.ora files permission is

# ls -l admin
total 112
-rw-r--r-- 1 oracle oinstall 14661 Apr 26 2002 libnk59.exp
-rw-r--r-- 1 oracle oinstall 643 Apr 26 2002 libnk59.imp
-rw-r--r-- 1 oracle oinstall 5728 Apr 26 2002 libnrad9.exp

[code]....

View 5 Replies View Related

Server Utilities :: KUP-00554 / Error Encountered While Parsing Access Parameters

Dec 2, 2010

I receive the following error message

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "binary_double,

[code].....

when I select count(*) on the external table created below.

SQL> CREATE TABLE cac_500_load
2 (
3 EMAILADDRESS VARCHAR2(80),
4 FIRSTNAME VARCHAR2(60),
5 LASTNAME VARCHAR2(60),
6 STREETADDRESS VARCHAR2(100),

[code].....

Here is the db version info:

SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT

View 12 Replies View Related

SQL & PL/SQL :: Escape Operator Symbol?

Feb 28, 2011

1) Can we set a different symbol other than '' for escape operator.
2) If yes, how to see the current escape operator symbol.
3) How to find out the below name with escape operator?

Employee name ----> rama_krishna_raj

View 2 Replies View Related

SQL & PL/SQL :: Join In A Query Which Has (+) Symbol At End

Oct 26, 2011

I have come across a join in a query which has the (+) symbol at the end of it.

View 3 Replies View Related

How To Get The Column Data Consist Of % Symbol

Mar 15, 2009

I want a query to get the column data , which consists of % symbol ,using like .

Sample :

The varchar data type column consit of columns 100%,100 ,90% ,77% with the Query i have to get the rows as 100%,90% ,77%. (i can get the data using in operator but i want to know how to get that using like).

View 1 Replies View Related

SQL & PL/SQL :: Trimming Euro Symbol In Given String

Nov 23, 2012

I am using the following query to trim the white space and enter character in the given string. BUt it is trimming the euro symbol also.

SQL> select regexp_replace(i_ruleexpression, '([^[:graph:]|^[:blank:]])','') into i_ruleexpression from dual ;
i_ruleexpression: Item.addChildByName("Advantage Smart 75 (-15€)")

View 11 Replies View Related

SQL & PL/SQL :: Insert Rupee (currency) Symbol

Apr 8, 2013

I want to display currency Rupee(Indian Currency) symbol in salary.

I am getting only $ symbol.

how to do it.

tell the process.

View 2 Replies View Related

JVM :: Ncomp Cannot Find Symbol TransitiveClosureDumper

Aug 22, 2012

I'm trying to ncomp a helloworld jar.I have already loaded the jar file in the db using loadjava. JAVA_HOME is pointing to ORACLE_HOME/jdk

While ncomping I'm getting the following error :

resolving: source oracle/jaccelerator/server/SQL
errors : source oracle/jaccelerator/server/SQL
oracle/jaccelerator/server/SQL:20: cannot find symbol
symbol: class TransitiveClosureDumper
public class MinimizeNcompListAndDumpTC extends TransitiveClosureDumper

Oracle Version is 11.2 on a linux box.

View 0 Replies View Related

Forms :: How To Display Password In Symbol Style

Dec 14, 2011

i want to make a form from creating new user and password but i don't know how to display password in *** style and how to save it with s-key character.

View 1 Replies View Related

Forms :: How To Validate Alphanumeric And Symbol In Textbox

Nov 12, 2012

I have created a form that have a button to check the character in the textbox is alphanumeric and symbol. Here attached the code, that i tried from other post.

View 5 Replies View Related

Client Tools :: Comment On Column With And Symbol?

Jul 31, 2012

I wanted to Comment on Column with & symbol. correct the syntax

Syntax
SQL> comment on column scott.emp.empname is ' Jerry&Tom. ' ;

ERROR
Enter value for t:
SP2-0546: User requested Interrupt or EOF detected.

View 5 Replies View Related

Reports & Discoverer :: How To Put New Indian Rupees Symbol

Sep 13, 2011

I want to put new indian rupees symbol in my oracle report i have put fornts in start > controlpanel >fornts. and i type this symbol in microsoft word also but i cannot put this symbol in oracle forms. So how can i put this symbol in oracle forms

i also read this [URL]...

View 4 Replies View Related

Client Tools :: Print Temperature Along With Its Symbol?

May 23, 2012

I need to print temperature along with its symbol. how it is possible in oracle reports? for example 45 (degree centigrade in symbol format.)

View 5 Replies View Related

SQL & PL/SQL :: TRIM Function - Remove Symbol Only From LEFT Or RIGHT Side

Feb 22, 2011

Is there any possibilites to remove the symbol '*' only from LEFT or RIGHT side, instead BOTH the side.

select '>' || trim (both '*' from '***removing stars at both sides***') || '<' "Stars removed" from dual;

View 4 Replies View Related

Client Tools :: To See Euro Symbol In PL/SQL Developer On Windows 7

Nov 22, 2012

When I try to select euro symbol in a table it is showing as '¿' in pl/sql developer on windows 7 where as I am able to see in windows XP.

SQL> select '€' from dual;

'¿'
---
¿

suggest to get the euro symbol.

View 1 Replies View Related

Reports & Discoverer :: Rupees Symbol On Linux Environment In 6i

Nov 30, 2011

I have one problem related to run Report 6i on Linux Environment.I have created new report with New Rupees Symbol(Rupee foradian) for Windows Operating System it is working properly appears new rupees symbol sign properly.

But i compile same report in linux environment and after that run through browser new rupees symbol not show properly instead of rupees symbol `(entitled sign)appears on my report.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved