desc entite Nom NULL Type ------------- -------- ----------------- ENT_SEQ NOT NULL NUMBER(38) ENT_CODE_ENT NOT NULL VARCHAR2(6 CHAR) ENT_GPL_ID NOT NULL NUMBER(10) ENT_OLS_EXE NOT NULL NUMBER(38) ENT_TYE_SEQ NUMBER(38)
when I want to create a table.When I run my procedure I received : PL/SQL: numeric or value error: character string buffer too small
create or replace PROCEDURE p_create_tmp_tables (p_result OUT NUMBER ) IS string_sql varchar2(1000); result NUMBER; BEGIN string_sql := 'CREATE TABLE TMP_CATEGORIES (CODE_CATEGORY NUMBER(6,0), NAME_CATEGORY VARCHAR2(25 BYTE))'; execute immediate string_sql; [code]...
begin -- Initialize owa with an empty array, just so we can use htp. owa.init_cgi_env( param_val=>owa.cgi_var_name ); -- Add a header to avoid dealing with header-related code in htp. htp.prn('Content-Type:text/plain'); htp.print('');
[code]....
The error I am getting is
ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.HTP", line 1550 ORA-06512: at line 32
what i feel is that oracle Database UTF8 or AL32UTF8 characterset does not support htp package properly. When i run the code on another characterset, it runs errorfree except in UTF8 or AL32UTF8.
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,
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
I am learning pl/sql and this is procedure i had created which got created successfully.then i created two variables name v_name, v_loc with command.
variable v_name varchar2; etc. and executed procedure like execute dept_proc2(10, :v_name, :v_loc); and i am getting the error
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
1 create or replace procedure dept_proc2 2 (v_dno in number, v_name out varchar2, v_loc out varchar2) 3 is 4 cursor dept_cur is select dname, loc from dept 5 where deptno=v_dno; [code]...
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.
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
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' ===
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
i have succusffly install webutil and also i did configuration also using this url
[URL]...
and i succussfuly upload and download .pdf using my form on my test database server my test database its a single database its version also 10.2.0.4.0 .but when i upload and download my .pdf file on my live database server using this same form its give me error while upload
my live database server its a RAC Database server its version 10.2.0.4.0 . i serach on google on this ora-06509 they told me
Cause: This indicates a version clash between some package distributed with an Oracle product and the product executable. Action: Contact Oracle Support Services.
but my question its my test database server and live database both server version are same its 10.2.0.4.0 just only its differece its test database its a single database server and live its a rac database server.
I have a column which has has all numeric values 3 digits to 7 digits in length but all in string format, I want to use seomthing other than to_number function.
Would like to use within the ETL tool, where to_number function isn't getting recognized.
i face this problem since a week. the form which was working fine till last week suddenly started giving this error when button pressed
"frm 40735 when button pressed returned trigger raised unhandled exception ora 01722"
i have not made any changes to the form or procedure, but suddenly its not working. the same form works fine in a laptop . i copied the same form to check if there is any changes happened, but yet its not working.
i checked in many forums , but not many seem to mention about ora 01722 even though they mention about frm 40735. In one of the forum it says to recompile the form and create a fresh .fmx file. I did that but yet it gives the same problem.
I have a form which contains tabular layout which i can fill a text item with date format. I set the data type properties to "Date" with format mask "dd-mm-yyyy".When I click a "save" button, it will call a procedure to insert into table. But i'm getting this error message : "FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502"
I did some search on google and error 06502 means numeric or value error. But I don't understand what caused my error. Is it at my text item's properties?
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.
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)
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.
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;
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)...
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.
SQL> ed Wrote file afiedt.buf 1 begin 2 for i in 3159572060..3159572274 loop 3 insert into recmsisdn(msisdn) 4 values(i); 5 end loop; 6* end; 7 / begin * ERROR at line 1: ORA-01426: numeric overflow ORA-06512: at line 2
