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


ADVERTISEMENT

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 :: 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

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 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

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

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 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

Reports & Discoverer :: How To Print Copyright Symbol In Rdf Report

Jul 17, 2012

how to print copyright symbol in rdf reports. I receive a ? when it gets printed.

View 3 Replies View Related

Reports & Discoverer :: How To Set New India Rupee Symbol In Report

Jan 7, 2012

I want to know how to set new India rupee symbol in report.I have change the format and paste that icon but when run report it's not showing that report.

View 3 Replies View Related

Reports & Discoverer :: Recover From Hour Glass Symbol

Mar 21, 2011

I have logged into Oracle and Discoverer several times and every time when I'm running a report in Discoverer, it quits responding. This is after I already have the data, and I'm scrolling to the bottom of the data to get the next 10,000 rows.

I just get the "hour glass symbol" and then i basically have to shut down and restart my computer.how to recover from these type of hour glass symbol.

View 2 Replies View Related

Precompilers, OCI & OCCI :: Unsatisfied Code Symbol (dladdr) In Load Module?

Jul 15, 2008

Recently, i had to restore /usr/lib folder (because some files crashes) to a previous point. This restore point is previous to Oracle client installation. Well, now, when i try to compile my Pro*C samples:

# make -u -f demo_proc32.mk sample1
/usr/ccs/bin/make -f
/oracle/oracle/product/10.2.0/client_1/precomp/demo/proc
/demo_proc32.mk OBJS=sample1.o EXE=sample1 build

[code]...

Can i fix it without re-installing Oracle client?

View 1 Replies View Related

Client Tools :: Unable To Insert Euro Symbol In Database With Character Set WE8MSWIN1252?

Mar 29, 2011

I am using oracle 9.2.0.6.0 on HP-UX.

I am unable to insert and even display euro symbol from server as well as windows client.

Following are the details of my database server

SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252

[code]....

1) When I try to insert € from Db server (using putty) using Alt+0128 it does not print anything (nothing gets typed on the screen). Not even junk characters Also following query does not print anything

SQL> select chr(128) from dual;
C
-

2) while I set NLS_LANG on client and try to insert €, Alt+0128 produces a question mark symbol And following query displays junk character

SQL> select chr(128) from dual;

C
-
Ç

3) Regardless when I inserted couple of rows and tried UNISTR following was the result

SQL> select unistr(v) from t;
Error 45 initializing SQL*Plus
Internal error
$

View 19 Replies View Related

Reports & Discoverer :: Symbol In Oracle Reports

Oct 29, 2011

I have a report I am currently working on...see attached file. I have circled two symbols. I know the one on the left is "page break after" but I am not sure why this field would have this setting.

Tell me what the symbol on the right means? Also, I have confine and flex set to "off" on all fields and items, yet when I move one of the fields other fields start to move as well. I am supposed to swap the bill to and ship to address which should be simple but so far it's not.

View 4 Replies View Related

PL/SQL :: SQL To Find Out Changes?

May 17, 2013

I have a table with 50 columns, lets call it Table_A . There is a identical table called Table_B. The data in Table_B gets flushed every night and data from Table_A is moved to Table_B. A new set of data is inserted into Table_A. Now I need to find out which field value is changed and what is changed . A minus command can give the changed records, but how to get the what was prior value for each changed field . Here is what I am looking for

WITH TABLE_A AS  (  SELECT 1 ID, 'JOHN' NAME,  'SALES' DIV FROM DUAL
UNION
        SELECT 2 ID, 'MARRY' NAME,  'ACCOUNTS' DIV FROM DUAL
UNION
        SELECT 3 ID, 'KIM' NAME,  'SERVICE' DIV FROM DUAL),

[code]...

what i want is something that will spit out this (only one record, because there is only one diff record found in the above query.)

ID,     OLD_ID,     NAME,   OLD_NAME ,  DIV ,       OLD_DIV
--      ------      ----    --------    ---         -------
3           3       KIM       KIM       SERVICE     SALESThe above one is for sample purpose, The actual table has 50 fields, and except the ID field, all other field values might change.

View 10 Replies View Related

SQL & PL/SQL :: How To Find Pk1_value

Mar 28, 2011

i need more important to know about this query,below query in where clause i have one condition like 'pk1_value =New_Deliveries.DELIVERY_ID" but in my New_Deliveries table i don't have pk1_value column,how to find that column.

select MAX(DECODE(fndcatusg.format,'H', st.short_text,NULL,st.short_text, NULL))
FROM fnd_attachment_functions fndattfn,
fnd_doc_category_usages fndcatusg,
fnd_documents_vl fnddoc,
fnd_attached_documents fndattdoc,
fnd_documents_short_text st,
fnd_document_categories_tl fl
[code]....

View 3 Replies View Related

SQL & PL/SQL :: Find Inserted Row

May 30, 2012

i m create a table emp . all user of database have privileged to read and write the emp table. now How can identify that which user have insert row in emp file ?

View 4 Replies View Related

SQL & PL/SQL :: Find Last Day Of Given Month?

Sep 25, 2012

I am facing a problem to find the last day of the month which is stored in a variable. i tried the following query which gave me an appropriate answer

select to_char(last_day(sysdate),'DD-MON-YY')from dual

ans : 30-SEP-2012

But I am having only the month in my hand through which I want to find its last day. I cant use sysdate for my query.

View 2 Replies View Related

SQL & PL/SQL :: Best Way To Find Duplicates?

Feb 14, 2012

I have to load 50 Million records in a table. I also need to ensure that no duplicate records enter. Business demand is that It may send 2 Million records today, 1 Million records tomorrow, 3 million records on the next day and so on...

I have loaded 6 Million records into the table, but onwards speed of loading records (with duplicate check) is decreasing.

View 16 Replies View Related







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