Forms :: Trigger Causing Error ORA-06502 And ORA-01403?

May 2, 2006

My layout is working well enough triggers though are causing me some problems. I am getting the following error message just about every time I write a trigger so I am getting the feeling I am doing something fundamentally wrong. Like there is something I am just not getting because I am getting this error on the simplest of actions.

The error:
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502.
--------------------------------------------------------------
ORA-01403: no data found

The trigger is this:
cs3_prog.set_date_mode;

this calls the following procedure in the package cs3_prog:

procedure set_date_mode IS
BEGIN
:cs3_data.street := 'something';
end;

this in the past did a lot more but I kept throwing stuff out to see what could have been causing the problem. This does actually work if I ok through the first error message and then try entering data again into the field the trigger is tied to. On this second firing of the trigger is does successfully alter the value.

Just the fact that this is happening every time I create a trigger and it seems to happen regardless of what I have the trigger doing leads me to believe I have something fundamentally wrong and I would love to have it set straight.

View 11 Replies


ADVERTISEMENT

SQL & PL/SQL :: Error In Trigger ORA-01403 - No Data Found

Apr 4, 2011

I got this error on the code below when i insert for example a record in a table "pedidos_teste" (insert into sgc_supergestor.pedidos_teste select * from sgc_supergestor.pedidos where IDPC=181 and IDPEDIDO=48 )

Below is the error: ORA-1403: ORA-01403: no data found

CREATE OR REPLACE TRIGGER SGC_SUPERGESTOR.pedidos_teste_I_U_D
after INSERT OR DELETE OR UPDATE ON SGC_SUPERGESTOR.PEDIDOS_TESTE
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
[code]....

View 6 Replies View Related

Forms :: ORA-01403 Value Will Be Sitting According To Post Trigger Of Previous Text Field

Jul 26, 2010

I have sort button that have the following code

go_block('TEL_OTHER_INFO');
set_block_property('TEL_OTHER_INFO',order_by,:system.cursor_item);
execute_query;

I have in the same form display item that its value will be sitting according to the post trigger of the previous text field when i press the sort button i get frm-40735 post-text-item unhandled exception Ora-01403 error.

View 2 Replies View Related

Forms :: Frm-40375 / When-validate-item Trigger Raised Unhandled Exception ORA-01403

Mar 6, 2011

frm-40375: when-validate-item trigger raised unhandled exception ORA-01403.

i put a new column which is the birth date and i made a new procedure with regards to the age level for the Plan. and when i run the program, theres an error..

View 14 Replies View Related

Forms :: Frm-40735 Pre-query Trigger Raised Unhandled Exception Ora-06502

Jun 17, 2013

When i select Filnumber(DEC99) and press QUERY button, i get error"frm-40735 pre-query trigger raised unhandled exception ora-06502".

View 1 Replies View Related

Forms :: FRM-40735 / WHEN-BUTTON-PRESSED Trigger Raised Unhandled Exception ORA-06502

Oct 3, 2013

I have Forms 6i, installed in a system at remote location with OS Windows 7. Previously the same was installed in Windows XP it was working fine. Now in Windows 7 also its working fine for most of the things, for some data loading options its not working and showing below shown error.

FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502

View 1 Replies View Related

Forms :: Error ORA-06502 In BLOB Retrieval?

Oct 29, 2012

I'm trying to develop a procedure which will read a BLOB field of a table and write an RTF document which will be used as template to another procedure but when the procedure fires up the select statemente, i got stuck with a ORA-06502 error.

This error, after reading the documentation, is caused by incompatibilities between fields (numeric or value error string) But i've seen this example everywhere in the internet and what is causing it.

The source code of my procedure follows:

PROCEDURE p_transfer_db_client(pcPath IN VARCHAR2,
pnSequence IN NUMBER) IS
v_src_blob BLOB;
v_file UTL_FILE.FILE_TYPE;

[code]...

View 1 Replies View Related

Forms :: ORA-06502 - PL/SQL - Numeric Or Value Error - Character String Buffer Too Small

Oct 2, 2010

i am generating html format mail from oracle 10g database.

For displaying data into html format, message body data is exceeding more than 32k.

ORA-06502: PL/SQL: numeric or value error:character string buffer too small

i am using long data type for message body data.

View 4 Replies View Related

XML DB :: DeleteXml() Causing Data Format Error In Database

Jul 21, 2013

I'm using the oracle  xml db 11g in my website application. Last week I found that using the deletexml() to delete a node in the xml may cause a terrible problem that the rest data in the database had wrong xml format. I wonder is it a bug when using binary xml storage.  My xml data is describe below, 

<root>     <nodes>          <node id="1">               <name>John</name>               <age>16</age>               <hobby>football</hobby>          </node>          <node id="2">               <name>Alex</name>               <age>22</age>               <hobby>table tenisl</hobby>         </node>           .....     <nodes></root>  

I using deletexml() to delete just a node once time, "update projects set object_value=deletexml(object_value, '/root/nodes/node[@id="1"]')" Usually it successes and the rest data is as expected, but sometime, I find that after deleting a node, any query in the database except "select * from projects" gets null. And the rest data has wrong format like below,

<root>     <nodes>          <node id="1">               <name>John</name>               <age>/hobby>          </node>          <node id="2">               <name>Alex</name>               <age>22</age>               <hobby>table tenisl</hobby>         </node>           .....     <nodes></root>

Just one format error causes the whole xml data valueless, but it seems that in most time the deletexml() works well.

View 8 Replies View Related

Error Due To Precision Value - ORA-06502

Aug 23, 2012

I got the error "ORA-06502: PL/SQL: numeric or value error: number precision too large" while assigning a value to variable.

For example var Number(5,3);
var:=225.345

Here it should give this error since the no.of digits before decimal should not be more than 2.

In of the procedure, I am getting this error.

Is there any way can we check this violation before assigning this values to a variable?

For example, if the value is too large, we can give a default value etc before assigning it.

Environment: UNIX AIX - 5.3, Oracle 11.2.0.1

View 3 Replies View Related

ORA-06502 - PL/SQL - Numeric Or Value Error

Jul 29, 2011

I have a requirement in which I have to append LOBs and I have to insert the LOB into a table column. I am facing problem when the data exceeds certain limit. (please note that my program logic is given below, not the exact program)

DECLARE

final_html CLOB;
int_html CLOB;
v_str VARCHAR2(32767);
i number:=0;
BEGIN
dbms_lob.createtemporary(lob_loc => int_html, CACHE => TRUE, dur => dbms_lob.CALL);
dbms_lob.createtemporary(lob_loc => final_html, CACHE => TRUE, dur => dbms_lob.CALL);
DBMS_LOB.OPEN(int_html, DBMS_LOB.LOB_READWRITE);
DBMS_LOB.OPEN(final_html, DBMS_LOB.LOB_READWRITE);
dbms_output.ENABLE(1000000);
[code]....

when the looping is done for lesser value say for e.g FOR i IN 1..10 loop, the program works fine, but when the looping is done for more values I am getting "-6502-ORA-06502: PL/SQL: numeric or value error" error message.

View 1 Replies View Related

SQL & PL/SQL :: ORA-06502 - Numeric Or Value Error?

Dec 18, 2012

create or replace package pckname is
Procedure VALIDATE_USER(p out credentials.pc%TYPE,
u in credentials.uc%TYPE,
c in credentials.sc%TYPE);
end pckname;

I m getting error at line 1 and line 8:

View 1 Replies View Related

SQL & PL/SQL :: Error ORA-06502 Caused By Select?

Nov 20, 2010

I have clob column which can have text of any size and any kind of text etcwhen I select using

select ef.finding_number,
ef.recommendation,epf.action_taken_desc
dbms_lob.substr(epf.action_taken_desc, dbms_lob.getlength(epf.action_taken_desc), 1)
as action_taken_desc,

[code]....

I get this error
Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1

then I tired with this query it worked
select ef.finding_number,
ef.recommendation,epf.action_taken_desc,
epf.concur_y_n

[code]...

should I use any functions to select clob ?

View 2 Replies View Related

SQL & PL/SQL :: ORA-06502 / Numeric Or Value Error - Number Precision Too Large

Dec 7, 2012

How many types of pl/sql value or numeric errors are there and when occurs.Like as follows

1.ORA-06502: PL/SQL: numeric or value error: character string buffer too small

2.ORA-06502: PL/SQL: numeric or value error: number precision too large

View 8 Replies View Related

SQL & PL/SQL :: ORA-06502 - Numeric Or Value Error - NULL Index Table Key Value

Aug 12, 2013

so im running this script

DECLARE
STQ_ID NUMBER;
MESSAGE VARCHAR2(500);

[Code].....

and getting this error ORA-06502: PL/SQL: numeric or value error: NULL index table key value

the code where it is inserting and getting out of it values is:

IF vt_Prs_Code_Ipr.COUNT <> 0 THEN
IF vt_Ist_Code_Ipr(1) IS NOT NULL THEN
IF vr_data.insurance_kind = 'B' THEN

[Code]....

Im running script at PL/SQL Developer and using debugger, i see that it's inserting dates but at some point between point 5.3.2.1.1 till 5.3.2.1.5 it returns no dates :/ basically it needs to stop at 5.3.2.1.2 and in form need return date 02.02.1996, but it returns 01.01.1996 + gives that ORA-06502: PL/SQL: numeric or value error: NULL index table key value

edit: vt_SnpStartDate(v_Idx)is 01.01.1996
vt_SnpEndDate(v_Idx) is 31.12.1996
vt_prd_tbl(v_Idx2).Start_Date is 01.01.1996
vt_prd_tbl(v_Idx2).End_Date is 01.02.1996

at p.5.3.2.1.3 it shows that there is no date in vt_prd_tbl(v_Idx2).Start_Date and is returning ora error, why?

View 10 Replies View Related

SQL & PL/SQL :: ORA-06502 - Numeric Or Value Error - Character To Number Conversion?

Aug 4, 2011

I got a string in the form 1+2+4.If we write select 1+2+4 from dual;then we get o/p as 7.but the same thing iam trying to do in a bit of pl/sql program by passing the string 1+2+4 value to a number variable as below.

COUNT_TASK := TO_NUMBER(TASK6_STATUS);

TASK6_STATUS value is 1+2+4 (this thing i got by replacing the string and lots of stuff) but i need the result after adding these 3 numbers in the string. and i declare COUNT_TASK as NUMBER;and i am very well aware that it gives me the error ORA-06502: PL/SQL: numeric or value error: character to number conversion error

how to add these numbers in my program to get the result 7.

View 6 Replies View Related

PL/SQL :: ORA-06502 - Numeric Or Value Error - Character To Number Conversion?

Jun 20, 2013

1 error has occurred  ORA-06502: PL/SQL: numeric or value error: character to number conversion error

I get the above error when I try to compare the below dates in a Pl/sql process in APEX environment.

Is there a work around for it? or (to_char(V_SERVFROM,'mm/dd/yyyy')) != (to_char(:P29_SERVFROM,'mm/dd/yyyy'))

View 4 Replies View Related

SQL & PL/SQL :: ORA-06502 Numeric Or Value Error / Character String Buffer Too Small

Jul 14, 2011

i am getting above error while doing

ORA-06502 numeric or value error: character string buffer too small
ORA-06512 itw_item_add_ch at line 17

CREATE OR REPLACE procedure itw_item_add_ch (header_id1 number, folio out varchar2,tariff out varchar2) as
cursor item_add(header_id1 number) is
SELECT
DISTINCT c.attribute4 item_tariff_no,
c.attribute5 item_folio
FROM OE_ORDER_LINES_ALL b,

[code].....

View 11 Replies View Related

SQL & PL/SQL :: ORA-06502 - Numeric Or Value Error - Character String Buffer Too Small?

Jul 10, 2012

Following are my declarations and query inside my procedure.i am getting "ORA-06502: PL/SQL: numeric or value error: character string buffer too smal" error when i try to execute the procedure

code :

request_owner request.SCC_USER_ID%TYPE := NULL;
receipt_location request.RECEIPT_LOCATION_LKP_ID%TYPE := NULL;
receipt_type request.RECEIPT_TYPE_LKP_ID%TYPE := NULL;
item_id request.ITEM_ID%TYPE := NULL;

[code]...

View 3 Replies View Related

ORA-06502 - PL/SQL / Numeric Or Value Error / Character String Buffer Too Small

Oct 8, 2012

Actually I have an existing table in LOG RAW instead of BLOB. Which stores some transaction XML data. The data is very huge. When i trying with the following, gives me following error

SQL> declare
2 a varchar(255);
3 B LONG RAW;
4 cursor c1 is select xml FROM LOG_tab WHERE ID='13148' ;
5 begin
6 open c1;
7 loop
8 fetch c1 into b ;

[code]....

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 10

Since dbms_output.put_line has buffer limitation.Can we write the result of a select statement into client LOCAL disk files using PL/SQL.

View 1 Replies View Related

PL/SQL :: ORA-06502 Numeric Or Value Error / Host Bind Array Too Small

Sep 25, 2012

While running by run script to perform few DMLs - im getting the ORA-06502 - PL/SQL:numeric or value error: host bind array too small.i ve put the server output off and then ON to clear the cache.Still same issue.

View 6 Replies View Related

SQL & PL/SQL :: Getting ORA-06502 - Numeric Or Value Error - Character String Buffer Too Small?

Jun 7, 2012

I am getting an error as below
ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

Here is complete code

CREATE OR REPLACE
TYPE MDI.ACCUM_STRING_TYPE2 AS OBJECT (
rvalue VARCHAR2 (32767
STATIC FUNCTION odciaggregateinitialize (sctx IN OUT accum_string_type2)
RETURN NUMBER

[code]...

View 4 Replies View Related

SQL & PL/SQL :: ORA-06502 - Numeric Or Value Error / Character String Buffer Too Small

Feb 17, 2012

ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8

I am reexecuting this view:

set serveroutput on buffer 2560000
;
CREATE OR REPLACE VIEW VIEW_TRIP_ASSIGNMENTS
(COMPANY_ID, TRIP_ID, TRIP_STOP_ID, TRIP_CODE, TRIP_NAME,
TRIP_DESC, TRIP_NUMBER, TRIP_START_TIME, TRIP_END_TIME, TRIP_LOADING_TIME,
TRIP_UNLOADING_TIME, FREQUENCY_ID, FREQUENCY_CODE, FREQUENCY_NAME, FREQUENCY_DESC,
FREQUENCY_CODE_NUMBER, CUSTOMER_ID, CUSTOMER_NUMBER, CUSTOMER_NAME, CUSTOMER_DESCRIPTION,
CUSTOMER_TYPE_ID, CUSTOMER_TYPE_NAME, CUSTOMER_TYPE_CODE, DAY_PHONE_NUMBER, EMAIL_ADDRESS,
CONTRACT_ID, CONTRACT_NUMBER, CONTRACT_DESCRIPTION, WORK_LOCATION_ID, ROUTE_ID,

[code]....

before reexecuting above view I was counting the column and was getting below error:

ora-00600 internal error code,arguments:[qctopn1], [],[],[]...

View 14 Replies View Related

Client Tools :: ORA-06502 - Numeric Or Value Error / Character String Buffer Too Small

Mar 28, 2013

Trying to learn and understand Triggers, PL/SQL code, etc. When I execute a simple insert using Toad for Oracle, all is fine. When I try the identical insert in SQL*Plus, it throws error ORA-06502 during execution of the trigger.

Here is the error info:

insert into AAAJOB(PROCEDURENAME,DESCRIPTION) VALUES('OOO','PPP')
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "PMSC0.AAAJOB_TIMING", line 10
ORA-04088: error during execution of trigger 'PMSC0.AAAJOB_TIMING'
===

Here is the table and the trigger:

CREATE TABLE PMSC0.AAAJOB
(
CREATETS TIMESTAMP(0) DEFAULT current_timestamp,
PROCEDURENAME VARCHAR2(100 CHAR),
DESCRIPTION VARCHAR2(100 CHAR),
LASTUPDATEDBY VARCHAR2(9 CHAR)
)

[code]....

The error seems to be on this:

SELECT current_timestamp
INTO :new_row.createTS

View 5 Replies View Related

Forms :: Error - Trigger Raised Unhandled Exception ORA-6508

Jul 8, 2011

I am trying to build one custom 10g form from TEMPLATE.fmb. when i try to compile my form in desktop it is giving error as Error FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508.

View 1 Replies View Related

Forms :: FRM-40735 / ON-ERROR Trigger Raised Unhandled Exception

Dec 21, 2010

I am using forms 10g developer suite, AIX in appl server.

When I run the form on my local drive through web I am getting error that,FRM-40735:ON-ERROR trigger raised unhandled exception ORA-06508.

My fmbs & fmxs are in e:fmb, libraries are in d:applicationlib.

FORMS_PATH in Registry is C:DevSuiteHome_1cgenf61admin;C:DevSuiteHome_1forms;e:fmb;d:applicationlib

I have set the same path in default.env also.What should I update, to run the form successfully.

View 3 Replies View Related

Forms :: Post-INSERT TRIGGER Raised Unhandled Error

Feb 9, 2011

I am facing a post trigger problem.No error while compiling.

DECLARE
mYPACCT VARCHAR2(10);
mTRNNO NUMBER; mVNO NUMBER; mSR NUMBER; mNARRATION VARCHAR2(200); mCHCODE VARCHAR2(10); mPARTY VARCHAR2(200);
mBRAND VARCHAR2(200); mYARN VARCHAR2(200);
BEGIN
BEGIN
SELECT YPACCT INTO mYPACCT FROM CONFIG;
EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
END;

[code].....

View 7 Replies View Related

Forms :: ON-ERROR Trigger Raised Unhandled Exception ORA-06508

Jan 18, 2007

I am in process of migrating Oracle 6i Forms to Oracle 10g Forms.

In 6i, the Form compiles and runs without any giving any error.

In 10g it does complie without any error but gives following Runtime Error Message -

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

View 15 Replies View Related

Forms :: FRM-40735 Or Error Trigger Raised Unhandled Exception ORA-03114

Jun 13, 2010

I am using database 10g and Form 6i. We are working under client server technology. Frequently we are receiving the following error to every user at randomly when they are idle few seconds/minutes.

FRM-40735 or error trigger raised unhandled exception ora-03114

View 5 Replies View Related

Forms :: When-Timer-Expired / Creating A Timer On On-Error Trigger Of Block

Jan 25, 2012

I'm having a problem with the When-timer-Expired trigger.I am creating a timer on the On-Error trigger of the block. in the when-timer-expired :

message (11); exit_form(no_validate);

If i run the program program for the first time,message 11 doesn't show thus it doesn't fire the when-timer-expired trigger. But if i logout from application server and enter all over again,the when-timer-expired works !

View 8 Replies View Related







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