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


ADVERTISEMENT

SQL & PL/SQL :: Compiling Package And Seeing Error

Jun 11, 2012

How to see the error Oracle is returning?

SQL> select owner, object_name, object_type from sys.dba_objects
2 where status = 'INVALID' order by owner;

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
CRMAPP
CRM
PACKAGE BODY

SQL> alter package CRMAPP.CRM compile;

Warning: Package altered with compilation errors.

SQL> show errors;
No errors.

SQL> select owner, object_name, object_type from sys.dba_objects
2 where status = 'INVALID' order by owner;

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
CRMAPP
CRM
PACKAGE BODY

View 2 Replies View Related

SQL & PL/SQL :: Error While Compiling Package Body?

Jun 28, 2011

When i compile the package body i get errors.

CREATE OR REPLACE PACKAGE BODY CEE_OSPCM_PKG AS
PROCEDURE CEEOT_WORK_TYPE_PRC IS
CURSOR CUR_WORK_TYPE IS
SELECT *

[code]...

View 7 Replies View Related

Forms :: Error While Compiling Package Body

Sep 3, 2010

while compiling this package body, i get error

error 102 at line 21 column 11
encounterd symbol "Group" when expecting one of following

begin function package pragma procedure subtype type use form cursor

View 5 Replies View Related

SQL & PL/SQL :: Compiling Package BODY Causes Invalidation?

Aug 25, 2010

Up until today we assumed that compiling a package BODY-only would not cause invalidation of other code. However when we compiled the body of the HTP package, the OWA package became invalid and required re-compilation.

Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE10.2.0.4.0Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

View 6 Replies View Related

SQL & PL/SQL :: Attach External File Using UTL_SMTP Package?

Feb 7, 2012

I want to attache an external file to a email using UTL_SMTP package.

A file which attach will be present in directory.

View 3 Replies View Related

SQL & PL/SQL :: Error In Compiling Procedure

Jan 3, 2012

i am new to oracle,when i am compiling below procedure,

create or replace procedure GetTempPolicyDetails2(i_officeid in number,pr_cursor out SYS_REFCURSOR) as

L_QUEY VARCHAR2(4000):= 'select POLTMP.POLICY_ID,POLTMP.CORPORATE_NAME,POLTMP.POLICY_FROM_DATE,POLTMP.POLICY_TO_DATE,
POLTMP.NETPREMIUM_WITH_SERVICE_TAX,
IOF.OFFICENAME,UW.NAME,REG.REGNAME,brmstr.brokername,created_on
from policies_temp POLTMP
INNER JOIN ISSUINGOFFICE IOF ON IOF.ID=POLTMP.Divisionid
INNER JOIN REGION REG ON REG.ID=IOF.RID
INNER JOIN underwriters UW ON UW.ID=REG.UWID
LEFT OUTER JOIN broker_master BRMSTR ON BRMSTR.ID=POLTMP.Broker_Name
where POLTMP.Policy_Status=1 where 1=1'
L_WHERE VARCHAR2(4000):='WHERE 1=1';
[code]....

View 5 Replies View Related

PL/SQL :: Error Compiling Procedure?

Jul 31, 2012

I'm getting the following error on a procedure that I was able to compile until today after some changes.

ORA-06550: line 354, column 20:
PLS-00103: Encountered the symbol "AND" when expecting one of the following:
. then or
The symbol ". was inserted before "AND" to continue.

View 6 Replies View Related

Forms :: Compiling Error When Using Bulk Collect In Oracle 10g?

Mar 15, 2010

i am getting compiling error when using bulk collect in oracle form 10g

Quote:this feture is not supported on client-side programs

View 3 Replies View Related

Precompilers, OCI & OCCI :: PCC-S-02014 Error While Compiling Within Sun Solaris?

Dec 18, 2008

We are porting our application from HP-UX to Sun Solaris and as part of that I am trying the compile a Pro*C program in Sun Solaris using SUNWspro C++ compiler. Precompiling is failing with following error.

PRECOMP set: /u01/app/oracle/product/10.2.0/bin/proc dbms=native code=cpp mode=ansi include=/u01/app/oracle/product/10.2.0/precomp
ireclen=255 oreclen=255
define=__sparc define=__SUNPRO_C include=/usr/include include=.

[code]...

System default option values taken from: /u01/app/oracle/product/10.2.0/precomp/admin/pcscfg.cfg

Syntax error at line 44, column 30, file /u01/app/SUNWspro/prod/include/CC/stlport4/algorithm:
Error at line 44, column 30 in file /u01/app/SUNWspro/prod/include/CC/stlport4/a
lgorithm
# include _STLP_NATIVE_HEADER(algorithm)
.............................1
PCC-S-02014, Encountered the symbol "(" when expecting one of the following:

[code]...

Normal C++ files are getting compiled with out eny issues. This particular file is having functions written in C fashion.

View 1 Replies View Related

Precompilers, OCI & OCCI :: Compilation Error When Compiling Code

Apr 2, 2009

I'm running a query similar to the one that I'm describing below -:

EXEC SQL INSERT INTO TABLE1
( C1
,C2
,C3
,C4 )
[code]....

Above query runs perfectly on SQL prompt.Same query, when being run in a Pro*C program gives compilation error-:

Error at specified line:

,( SELECT D.V3 FROM TABLE2 D WHERE D.V3 = C.V4)
.............................1
PCC-S-02201, Encountered the symbol "D" when expecting one of the following:
( ) * + - / . @ | at, day, hour, minute, month, second, year,

What are the possbile causes of error. I am using Oracle 10g on Unix.

View 1 Replies View Related

PL/SQL :: Error While Compiling Procedure / ORA-01031 / Insufficient Privileges

Jan 22, 2013

how to grant compile access for stored procedures..? I got execute access so that i can execute procedure from another user but not able to save/modify once i edited.

i am trying to compile using SQL developer. Error Message :Error: ORA-01031: insufficient privileges

View 5 Replies View Related

SQL & PL/SQL :: Compiling Invalid Objects Results In ORA-03113 Error

Mar 19, 2011

I am getting the following error while compiling the invalid objects.

ERROR at line 2: ORA-03113: end-of-file on communication channel

I am trying to compile the invalid objects after importing the dump file.

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

SQL & PL/SQL :: External Table Error

Jan 28, 2011

I have an external table. The table gets created successfully. Once the table is created when I try to access it, I get the following error :

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file /cmpnt/dev/test/ADE_TEMP_4992.log

The default directory is valid and does not have any issues. The IP address of my DB server and the server from which I am connecting to the DB are different. Is this is the issue ? However , all SQL queries are working fine except this one.

View 1 Replies View Related

SQL & PL/SQL :: External Table Syntax Error

Jul 5, 2012

SQL>

create table oldemp8
(
fname varchar2(30),
salary number(6),
job_id varchar2(20)
)
[code].......

Table created.

SQL> select * from oldemp8;
select * from oldemp8
*
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 "(": expecting one of: "comma, defaultif,
nullif, )"
KUP-01007: at line 7 column 16
ORA-06512: at "SYS.ORACLE_LOADER", line 19

SQL>

what is the syntax error in the above command. I place the notepad file properly.i create external table before many time but cant find any this type of error.

os windows xp 2000. oracle 10g (10.2.0.1.0)

View 7 Replies View Related

Error While Calling External C Function From Oracle?

Apr 7, 2011

I tried to use external C procedure from the database and i did all required steps as below.
1. create a C program
2. compile and link the C program
3. copy it to the Oracle_home/bin directory
4. configure listener.ora and tnsnames.ora files

listener.ora
=======
callout_listener =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP) (HOST = ip_address)(PORT = 1521)

[code]...

View 4 Replies View Related

SQL & PL/SQL :: Oracle 9i External Table Error - ORA-29913

Aug 12, 2011

I have a problem here I am using this script to create an external table

CREATE TABLE SUPP_GIM.T_CSV_DATA
(
UPC VARCHAR2(30),
AGEIND VARCHAR2(30),
DEPT VARCHAR2(30),
CREG VARCHAR2(30),
SUPP VARCHAR2(30),
PRICE VARCHAR2(30),

[code]....

I have created the directory pointing on 'C:data'...And loaded a comma delimited CSV file in there...

- Checked the csv permissions ther are set to 'everyone'

- Checked the previladges of the directory, they are set to 'READ/WRITE'

But when I issue a select statement against the exte table I get an error '

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file input.csv in DUMP_TXT not found
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1'

View 3 Replies View Related

Server Utilities :: External Table - Data Cartridge Error

Aug 6, 2010

i created the External Table using the script below.

CREATE TABLE EXT_ST_FINANCEIRO_REAL (
DT_DATA NUMBER,
TIPO NUMBER,
ENTIDADE NUMBER,
VALOR Varchar2(40))
[code]....

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 "missing" expecting on of: "column, exit,("
KUP-01007: at line 6 column 1
ORA-06512: at "SYS.ORACLE_LOADER", line 19

View 3 Replies View Related

SQL & PL/SQL :: Package Compilation Error

Jan 4, 2012

when am trying to compile package, am getting the below error am not understanding whats that exactly ,

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

end not pragma final instantiable order overriding static
member constructor map

View 3 Replies View Related

SQL & PL/SQL :: Package Error - Invalid Identifier?

Mar 4, 2012

way give error in package below

SQL> CREATE OR REPLACE PACKAGE DATA_BKG AS
2
3 TYPE OBJ_DEPT IS RECORD
4 (
5 DEPT_ID NUMBER(10),

[code]...

View 7 Replies View Related

SQL & PL/SQL :: Numeric Or Value Error In Stored Package

Oct 28, 2010

I am getting the below error in a Stored Package.

SQL> BEGIN
2 NCOTE.OTEGENERATOR;
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "GENEVA_ADMIN.NCOTE", line 3
ORA-06512: at line 2

I must be trying to do a select or put some other value into a variable that is too small. The Odd thing is that when I run the stored procedure again (as long as I don't exit from sqlplus)...

SQL> BEGIN
2 NCOTE.OTEGENERATOR;
3 END;
4 /
PL/SQL procedure successfully completed.

why the process is successful the second (or third, etc) call from the sqlplus but not the first. If I exit sqlplus and then start it again, once more I get the error again.

View 6 Replies View Related

SQL & PL/SQL :: Package Variables And Execution Error

Sep 27, 2013

I have a package with pipelined function in it. using the below stmt to execute the function in Oracle 11g.

select * FROM table(Test_PKG.Test_PIPELINED ('A','--N/A--','1/1/2010','1/1/2011'));

Throwing an error: invalid month error.

CREATE TYPE WBS_ROW IS OBJECT
(
Product VARCHAR2 (100),
DESC VARCHAR (1000),
RecDATE DATE);

[code]....

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

PL/SQL :: Error While Running UTL_MAIL Package

Aug 8, 2012

SQL> conn system/sys@ORCL;
Connected.
SQL> @F:oracleproduct10.2.0client_5RDBMSADMINutlmail.sql

Package created.
Synonym created.

SQL> @F:oracleproduct10.2.0client_5RDBMSADMINprvtmail.plb

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY UTL_MAIL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
319/5 PL/SQL: SQL Statement ignored
320/10 PL/SQL: ORA-00942: table or view does not exist
325/7 PL/SQL: SQL Statement ignored
326/12 PL/SQL: ORA-00942: table or view does not exist

View 2 Replies View Related

PL/SQL :: Error When Subtracting 2 Dates In Package Using Toad?

Oct 21, 2013

I am having a problem when calculating dates in a package usiong Toad. I have my function : 

FUNCTION PORTFOLIO_MEMO_RPT_Sql( schema_name IN  VARCHAR2  , select_business_date IN  DATE ) RETURN VARCHAR2.....SELECT DISTINCT       Case     when NVL(TO_DATE(''09/24/2013'',''MM/DD/YYYY'') - DECODE(mn.Active, 1, mn.DueDate, sc.DueDate ),0) = 0 then ''0Days''     when NVL(''' || select_business_date  || '''   - DECODE(mn.Active, 1, mn.DueDate, sc.DueDate ),0) = 0

then ..... when I give it my variable from outside , it is not working......but when I use a date inside, it works. I call my function from outside like :

SELECT * FROM  TABLE ( FI_rpt.Fi_Rpt_Pkg_loan.PORTFOLIO_MEMO_RPT (sys_context('userenv','session_user'),TO_DATE('09/24/2013','MM/DD/YYYY')) )

View 17 Replies View Related

PL/SQL :: Calling External C Function / ORA-06521 Error Mapping Function

Feb 4, 2013

I have the following C code:

class Factorial {
  public:
  int getVal (int a);
};
[code]....

/When I am trying to execute this function always get the ORA-06521. I changed the data types - but nothing changed.

Just in case, listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521))
                   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
[code]....

View 6 Replies View Related

SQL & PL/SQL :: External Table Query (compare Number Records In File With External Table)

Jan 23, 2013

I have got a procedure that successfully creates an oracle external table and populates it with the contents of a file. This works fine until I have a situation where one of the fields is a VARCHAR2(2) and I try to insert say, a 5 character value. When this happens the record in question does not get populated in the external table (and rightly so), but I could do with working out if there is a discrepancy in the number of records in the file and the number of records that actually make it into the table so I could inform the user that there is a problem.

I have attached the code that creates the external table and populates it.

View 5 Replies View Related

PL/SQL :: Find Out In Database Package Where Package Is Installed

May 28, 2013

I need to find out in DB Package where this Package is installed (in which schema). The problem is this DB Package can be installed in various schemas. This means that I can't use select user from dual or system environment SYS_CONTEXT('USERENV', 'OS_USER').

What I would need is something like $$PLSQL_UNIT

View 8 Replies View Related

SQL & PL/SQL :: Warning Compiling A Function

Feb 10, 2012

I have a requirement to reformat some data elements that consist of two numbers separated by a hyphen e.g. 123-456. I have written a function to get the first number but it compiles with a warning.

CREATE OR REPLACE FUNCTION get_lowernumber
(housenumber varchar2)
RETURN varchar2
IS
v_hyphen number;
[code].......

View 8 Replies View Related







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