PL/SQL :: ORA-06550 - While Compiling Block?

Apr 10, 2013

I am trying to resolve by using a cursor C2 inside the already existing cursor C1, i will use a inner loop to get the select statement value to cursor c2 then i will assign the vlaues the variables, then once i read all the values of cursor c2 i will exit inner loop and go to outer loop to read the next value of c1 and then again go to cursor c2 and inner loop.

I have pasted the code below.

Declare
temp1 source.source%type;
temp2 QUOTE_LETTERS_MASTER%rowtype;
Cursor c1 is
Select * from Source;

[code]...

View 5 Replies


ADVERTISEMENT

SQL & PL/SQL :: How To Handle Exception For ORA-06550

Nov 17, 2011

I trying to Assign XML content to the clob variable inside the pl/sql block, But i am getting the Below Error:

declare
t clob;
begin
t := 'xml content exceeds 32000 characters'

update test
clob_cloumn = t;
where id =2;

exception
when others then
null;
End;

ORA-06550: line 5, column 4:
PLS-00172: string literal too long

I need to handle this exception, i know it length exceeds 32000 characters, but even though i need to handle the exception and to perform other operation after handling the exception.

View 5 Replies View Related

SQL & PL/SQL :: Receiving ORA-00905 - ORA-06550?

Aug 15, 2013

I have a problem with the code below. I would like to define a variable (exrate1) which I would like to use in another script. Also, the variable should be different for every month(that's why timestamp is between some period).

The problem is that I receive some errors which I don't know haw to fix

View 8 Replies View Related

SQL & PL/SQL :: ORA-06550 / Error Executing Stored Procedure

Nov 18, 2010

Procedure: CREATE OR REPLACE procedure test (a number, b varchar2) is

begin
dbms_output.put_line(a ||'->'||b);
end;

Anyonymous Block:

begin
exec test(1,'m');
end;
/
When i run this i am getting this error
ORA-06550: line 2, column 7:
PLS-00103: Encountered the symbol "TEST" when expecting one of the following
[code]...

View 5 Replies View Related

SQL & PL/SQL :: Accept Input And Output To Screen - Getting ORA-06550 Error

Jan 18, 2011

I am trying to accept three numbers and one string as input, and then display the values on the screen. I don't understand why I am getting these errors.

SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 id_number NUMBER := &id_number_input;
3 trans_num NUMBER := &trans_num_input;
4 remar VARCHAR2(75) := &remark_input;
5 receipt NUMBER := &receipt_input;

[Code] .....

ERROR at line 4:
ORA-06550: line 4, column 24:
PLS-00201: identifier 'HELLO' must be declared
ORA-06550: line 4, column 8:
PL/SQL: Item ignored
ORA-06550: line 10, column 61:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 10, column 2:
PL/SQL: Statement ignored

View 3 Replies View Related

Windows :: ORA-02185 - A Token Other Than WORK Follows COMMIT ORA-06550

Feb 21, 2011

I am facing the below mentioned error with .net framwork and oracle.

PL/SQL: ORA-02185: a token other than WORK follows COMMIT
ORA-06550: line 1, column 7:
PL/SQL: SQL Statement ignored

View 3 Replies View Related

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

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

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

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

Forms :: ORA-31640 While Compiling Menu In 6i

Oct 22, 2011

I am getting this err ora-31640 while compling a menu in forms6i and when i have searched in oracle it is giving in forms 6i shared submenu's are not supported.

View 1 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 :: Form Closes While Compiling

Jul 20, 2010

I have a form, using views which has tables from other databases.

e.g. :my database name is G1 here i have a view

MR_HEAD

CREATE OR REPLACE VIEW MR_HEAD AS
SELECT "MR_HEAD_KEY","MR_TRAN_TYPE","MR_NO","MR_DATE","PO_TYPE","PO_NO","VENDOR_CODE",
"MODIFY_FLAG","SUPERSEDE_FLAG","REF_MR_HEAD_KEY","PO_KEY","PO_DATE","REJECTION_NO",
"USER_ID","LAST_UPD_DATE"
FROM INMATMAS.MR_HEAD@SPICFIN

i am linking my database G1 with Above Database. so after using this in my form as

'INMATMAS.mr_head@DB_OPTIMAT'[/email]

for insert/select. i cant able to compile it. form closes immediately when i compile this.

what must be the reason,

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

Precompilers, OCI & OCCI :: Pr-compiling Gtk Functions In C Files?

Aug 17, 2012

I'm having a problem pr-compiling gtk functions in c files.

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

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

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

Forms :: Upload Data Using 6i While Compiling Form Automatically Closed

Dec 6, 2010

i have create database link with msaccess2000 its working fine in forms 6i i am trying to upload data by using forms 6i while compiling form is automatically closed my code is this

begin
insert into baba1
(select *
from baba1@access_db
where dte between to_date(:block3.fdate,'dd-mon-yyyy')
and to_date(:block3.ldate,'dd-mon-yyyy')
[code]....

View 8 Replies View Related

Forms :: Multi Data Block And Checkbox Field Based On Control Block

Nov 19, 2010

i have multi data block filed. and checkbox field which based on control block...My task is when i check checkbox only one field should enabled and my mouse goes to that field

e.g

item11 item21 item31 chkbox1
item12 item22 item32 chkbox2

Scenario like this :

My item field based on data block and checkbox based on control block,while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field

when i checked chkbox1 , my cursor goes to item31...not item32

View 12 Replies View Related

Forms :: Distribute Master Block Total Amount In Detail Block Line Wise

May 5, 2012

i have a master detail form, In Master block we have one field cheque amount and in Detail block we have field receiveable amount invoice wise. if company paid us a cheque amount we will enter this amount in Master block field Cheque amount and in detail block there will be invoice wise receivable amounts. i want to distribute the cheque amount in detail block invoice wise for example

Cheque amount in master block = 291

Invoice wise receiveable amount is as follows

Invoice No , receivable amount , Received amount

10, 196 , 0
20 , 95 , 0
30 , 54 , 0

Result should be as follows:

Invoice No , receivable amount , Received amount

10, 196, 196
20 , 95 , 95
30 , 54, 0

Received amount field should be distributed according to the receivable amount when recevied amount = cheque amount then remaining will be 0.

View 2 Replies View Related

Backup & Recovery :: Error / Corrupt Block Relative Dba / 0x01c12a58 (file 7 / Block 76376)

Jan 25, 2011

i have an error with block corruption

Error: Corrupt block relative dba: 0x01c12a58 (file 7, block 76376)

What all the ,methods I can go for if we are working on a production environment with out any down time.

I can go for dbms repair package and restore and recover

View 3 Replies View Related

Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)

Jul 24, 2010

I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.

I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".

View 3 Replies View Related

Precompilers, OCI & OCCI :: Compiling C File (output Of PC File Precompialtion)?

May 4, 2010

after precompiling the cmpre.pc file, i got cmpre.c file. when i try compiling this .c file, am facing the following error...

servername:/.../home/usr/compile-> cc -g cmpre.c
ld: 0711-317 ERROR: Undefined symbol: .sqlorat
ld: 0711-317 ERROR: Undefined symbol: .sqlcxt
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.

View 1 Replies View Related

SQL & PL/SQL :: Junk Value In Block

Jan 5, 2011

I am running the stand alone pl/sql block. it opens the for cursor and the updating the table. select value in the cursor having 3 lack records. the server output is returning junk values. Why i am getting this junk value here.

below is the format:

SET SERVEROUTPUT ON

BEGIN
FOR cursor name select
LOOP
UPDATE table_name
END LOOP;
[code].....

View 6 Replies View Related

PL/SQL :: DB Block Gets While Delete?

May 22, 2013

From plan I would expect the delete command to be processed very quickly, however it does huge amounts of db block gets. I assume this is because of deleting the row from other structures (indexes, foreign keys in tables etc.) How can I find out which object scan caused the db block gets ?

SQL> delete from messages2 where id = 11004240718;
1 row deleted.
Elapsed: 00:00:03.79
Execution Plan
----------------------------------------------------------
Plan hash value: 140582024

[code]....

View 25 Replies View Related







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