gkaindia.com

Home > > Error in inserting data

Error in inserting data

Advertisement
Hi,
I have insert page i the developing instance it is working fine .
But in production after click on submit we have a dialog page saying that do u want to save the data . If the user clicks ok the data is saving in backend but its showing the error message in page that
u have encountered an unexpected error please contact system administrator. When we click no also its giving the same error.
When i enabled the FND_DIAGNOSTICS profile option it will work fine it will not give any error. If i disable then it will give error.
Please any one will help. what is the region and why it is giving error please its so urgent
Regards,
Sangu
Advertisement
Hi,
It is true that you cannot perform DML operations inside SQL (that is what discoverer do).
The way to work around it is to define the function that perform the insert as AUTONOMOUS_TRANSACTION
You should add the syntax to your function, for example:
CREATE OR REPLACE FUNCTION test1 RETURN INTEGER IS
i INTEGER;
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
i := 1:
insert into t
select i from dual;
COMMIT;
RETURN i;
END test1 ;
BTW don't forget the commit although it's GTT and make sure you preserve rows on commit;
Tamir
Read the other 15 answers
Error while insert data using execute immediate in dynamic table created in oracle 11g . first the dynamic nested table (op_sample) was created using the executed immediate... object is CREATE OR REPLACE TYPE ASI.sub_mark AS OBJECT ( mark1 number, ma
Hi, When inserting data into a field of datatype long in oracle8 database via SQL Plus or SQL worksheet there occurs the following error message: "field in data file exceeds the maximum length". If I access to the database from a selve written p
Hi, I am trying to insert data into a datagrid getting results from a cfc using remoteobject. If I use everything inline then it works fine. I have a button when clicked give me the results. if I have something like this: <mx:Button label="get Que
Hi', I am using SOA 11.1.1.5 I am inserting data using DB adapter in MS SQL Server. Some times I get below error. Error Message: {http://schemas.oracle.com/bpel/extension}bindingFault Fault ID     rrr/xxx!1.1*soa_313bd437-7bb9-41c6-a719-d1775b9afc4b/
Hi all, i am facing an ora 14400 error in the following scenario , please help. i have created a table using the syntax: CREATE TABLE temp_table GRPKEY NUMBER(20, 0) NOT NULL, UKEY NUMBER(10, 0), ANUM VARCHAR2(250 BYTE), APC VARCHAR2(2 BYTE), SID VAR
Dear Experts, I am trying to insert data into resume table, but it is throwing error: create table resume(resume blob); declare f_lob bfile; b_lob blob; begin insert into resume(resume) values(empty_blob()) return documents into b_lob; f_lob := bfile
Hi All,   I created a table.While inserting data into the table i am getting an error.Its telling "Create data Processing Function Module".Can any one help me regarding this? Thanx in advance anirudhHi Anirudh,   Seems there is already an entry
I have a data passed into the Event Hubs, queried by stream analytic job inserting it into sql database. Upon running the job, it becomes idle a few seconds after since it has an error: Message: Conversion from 0 to System.Boolean failed. 0 was of ty
Hello all, I have created a database link in oracle 11g to SQL Server 2008 using Sqlserver gateway for oracle,Oracle run on Linux and SQL Server run on Windows platform. I have queried a table and it fetches rows from the target table. I am using thi
Hi Experts, I am learning OAF; i am trying into insert the data into table using OAF. I followed the below procedure. My table(OLF_TEST_TBL) Columns: EmpID (Number), Ename(VARCHAR2 100), Sal Number, and who columns. 1. created Application Module (AM)
Hi All, I am very new to ODI, I am facing lot of problem in my 1st interface. So I have many questions here, please forgive me if it has irritated to you. ======================== I am developing a simple Project to load a data from an input source f
Hi, I had usermanaged cachegroup, it is working fine as expected when I insert the record on the ttIsql prompt but when I try to insert the record programmatically (using c language ) it gives me the following error for date field pthread_kill(??, ??
I have a partiotioned table with 20 columns .. out of 20, I have only one defined as not null.. So when I tried inserting the data in the column alone am getting the error : ORA-14400: inserted partition key does not map to any partition this is the
I am using SQL to store the data, When I am insterting the data to my table then I am getting error 2147217833. Attached image for table structure and method the way I am insterting the record. I am using LV2011. I am able to connect to database but
hallo, im trying to write a trigger like that : CREATE OR REPLACE TRIGGER raum_besetzt BEFORE DELETE OR UPDATE OR INSERT ON BUCHUNGEN FOR EACH ROW DECLARE v_p NUMBER; v_t NUMBER; BEGIN SELECT ANzahl_plaetze into v_p FROM RAEUME; SELECT ANzahl_teilneh
I am getting the "ORA-12899: value too large" error mesaage when inserting the date in to the timestamp filed using hibernate. This filed is getting populated from trigger using the sydate. Trgigger execute prior to the code.This code and trigge
Dear all i am using 10g Forms. I am using Text_io to read the text file and putting into table and again reading the tables and putting into another text file . I was testing in 3 tables which is the same copy of the original table but only the name
Hi , I tried the following insert command in the link http://www.oracle-base.com/articles/misc/RollupCubeGroupingFunctionsAndGroupingSets.php BANNER Oracle Database 10g Release 10.2.0.1.0 - Production PL/SQL Release 10.2.0.1.0 - Production CORE    10
Feed : <RESULT> <EVENT_ID>3710</EVENT_ID> <UPDATE_TIME>Oct 28 2000 11:30PM</UPDATE_TIME> <SPORT_ID SPORT_NAME_LONG="Basketball" SPORT_NAME_MEDIUM="Basketball" SPORT_NAME_SHORT="NBL">4</S