I'm inserting to a table through a procedure, I want to log the rejected records to a log table with the execption / reason.How can I get the exception name and error text in PL/SQL ?
View 20 RepliesI am getting following error in my alert log file of my database
ORA-07445: exception encountered [kduget () +1032][sigbus]
as i can perform some of my database activity but from some of the users i cannot login.
i tried to search out and found that some Memory needs to be flushed out so restarting of database is only action to be taken?
My cursor went to the exception when its got the error " ORA-01403: no data found"
But my cursor need to run even though it got the error " ORA-01403: no data found"...This is my exception part
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (c1rec);
DBMS_OUTPUT.put_line (SQLCODE);
DBMS_OUTPUT.put_line (SQLERRM);
-- RETURN NULL;
-- code change added as part of GCA642 -- END
END get_geo_test1;
I have installed Oracle 11gR2 on Windows 7 professional. I created a DB and a listener also.No issues there; I can connect to the DB with sqlplus and SQL Developer.when I try to configure dbcontrol on this DB, it fires errors;
--------------------------------------------------------------------------------------------
C:Windowssystem32>emca -config dbcontrol db
STARTED EMCA at Jun 7, 2012 2:20:15 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: ORA112
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableExcep
[code]...
How this can happen?
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 RelatedI am using Oracle 10.2.0.1.0. My intention is to create a new database instance.
Here are the steps I have taken,
1. Using DBCA, I created a new database instance, oracle sid = MYORCL0318
2. I created the tablespaces for this instance.(I obviously have not imported any data into this database yet.)
then, I went to Enterprise Manager,
Login = sys
password = xxxxxxx
role = SYSDBA
After I login, I would get an Error like this
java.lang.Exception: Exception in sending Request :: null
I am getting error message while installing oracle database gateway 11.2 on linux el6 64 bit machine
Error in invoking target 'install of makefile dg4mqs.mk'...if we ignore the error and continue...after installation we can see missing executable files .
when ever the developer connecting to database to generate froms or While trying to create inventory categories below error is appearing.
FRM-40735: On-error trigger raised unhandled exception ora-06508..
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.
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
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 importing a dump file which is of size upto 6GB, its working fine. At the last step after the import of all the tables when it enables constraints , indexed and everything a pop-up window with the above mentioned error in the subject pops-up.
I am not able to mention the error exactly so find the screen shot as attachment.
APEX 4.2Oracle 11g Database We are using the standard exception handler that was introduced in APEX 4.1, and we have code in packages & procedures in the database (following proper processes of keeping code in the database where possible). When an exception is found in the procedures/ packages/functions, should the APEX application level exception handler catch any errors that occur or should they be handled in the package/procedure/function they occurred in? Why I ask if, we right now have exception handling code in the pl/code bodies BUT they write their errors to the same table that Apex's Exception handler does, but the errors are NOT presented to the user using the APEX exception handling mechanism.
View 2 Replies View RelatedI have to implement exception handling in the exception block of a trigger, Quote:exception
when ora_java.java_error then
message( 'Unable to call out to java, ' || ora_java.last_error );
ORA_JAVA.CLEAR_EXCEPTION;
when ORA_JAVA.EXCEPTION_THROWN then
ex := ORA_JAVA.LAST_EXCEPTION;
message( Exception_.toString(ex));
-- lv_exception := Exception_.getMessage(ex);
I get an error for the line: 'message( Exception_.toString(ex));'I have imported the java classes FException et IObject with their methods.
I have to create a Web Service Client, so I wonder if the paragraph Quote:when ORA_JAVA.EXCEPTION_THROWN then ex := ORA_ JAVA. LAST_ EXCEPTION; is mandatory.
i am binding a string to a CONTAINS search (oracle text) and its throwing an error because of characters within the string.
this causes the error.
Quote:
(A. A.)
if i take out ( and ) it works
Quote:
A. A.
i thought binding took care of these issues as well as sql injection?
example:
SELECT
score(1) the_score,
id
FROM
t_table
WHERE
contains(text_column, :BINDVAR1, 1) > 0
how can i get around this and other character errors on the fly?
I've written a pl/sql to send mail. It works fine. Now i want to modify it to send an attachment txt/scv/xls file.This file is residing on client's pc.How to do it?
Following is pl/sql for sending mail.
create or replace PROCEDURE SEND_MAIL(P_SENDER IN VARCHAR2,P_RECIPIENT IN VARCHAR2,P_MESSAGE IN VARCHAR2,P_SUBJECT IN VARCHAR2 )IS
MAILHOST VARCHAR2(30) := 'MAILHOST.TIFR.RES.IN';
MAIL_CONN UTL_SMTP.CONNECTION;
BEGIN
MAIL_CONN := UTL_SMTP.OPEN_CONNECTION(MAILHOST, 25); -- TYPICALY 25 S THE PORT NUMBER FOR INCOMMING SMTP REQUESTS ON YOUR SMTP MAIL HOST
UTL_SMTP.MAIL(MAIL_CONN, '<'||P_SENDER||'>'); -- THE '<' AND '>' DEPEDS ON WHAT TYPE OF SMTP MAIL HOST U'RE RUNNING THIS ONE'S A NETSCAPE SMTPHOST
[code]......
Have got basic form on a table and have a textarea which holds Notes added by user.
So Notes database field is updated on Save / Apply changes button being pressed.But would really like any text added / appended to the Notes field to be prefixed by userid and date / timestamp.
Is it possible via dynamic actions or Javascript to have any new text added / typed to be auto prefixed as per above.
Would only want the first key press in the filed to trigger the auto-prefix and if added text was deleted then the auto prefix to be deleted as well ?? If user doesn't press Save / Apply changes obviously want to leave existing Notes as is.
Is there text changed trigger with text item function like when_list_changed trigger of list item?
View 7 Replies View RelatedCan I use rich text item on oracle form10G with some simple features like BOLD, UNDERLINE, ITALIC and if possible one more feature like spell check.
I Google my requirement, but mostly I found win word attachment. Further more if I can save this type of data in field then how can I print in report.
I am on Oracle 11.2.0.3 on Linux and have implemented Oracle Text.I created Oracle Text indexes with default setting. However in an oracle white paper I read that the default setting may not be right. Here is the excerpt from the white paper by Roger Ford:URL....(Part of this white paper below....)Index Memory.
As mentioned above, cached $I entries are flushed to disk each time the indexing memory is exhausted. The default index memory at installation is a mere 12MB, which is very low. Users can specify up to 50MB at index creation time, but this is still pretty low. This would be done by a CREATE INDEX statement something like: CREATE INDEX myindex ON mytable(mycol) INDEXTYPE IS ctxsys.context PARAMETERS ('index memory 50M'); Allow index memory settings above 50MB, the CTXSYS user must first increase the value of the MAX_INDEX_MEMORY parameter, like this: begin ctx_ adm. set_ parameter('max_index_memory', '500M'); end; The setting for index memory should never be so high as to cause paging, as this will have a serious effect on indexing speed. On smaller dedicated systems, it is sometimes advantageous to temporarily decrease the amount of memory consumed by the Oracle SGA (for example by decreasing DB_CACHE_SIZE and/or SHARED_POOL_SIZE) during the index creation process.
Once the index has been created, the SGA size can be increased again to improve query performance." (End here from the white paper excerpt)My question is:
1) To apply this procedure (ctx_adm.set_parameter) required me to login as CTXSYS user. Is that right? or can it be avoided and be done from the application schema? This user CTXSYS is locked by default and I had to unlock it. Is that ok to do in production?
2) What is the value that I should use for the max_index_memory should it be 500 mb - my SGA is 2 GB in Dev/ QA and 3GB in production. Also in the index creation what is the value I should set for index memory parameter - I had left that at default but how should I change now? Should it be 50MB as shown in example above?
3) The white paper also refer to rebuilding an index at some interval like once in a month: ALTER INDEX DR$index_name$X REBUILD ONLINE; We are on Oracle 11g and the white paper was written in 2003.
I have a requirement in one of my forms screen.I have a text box(large text area) which should display a help text file when i move my cursor on the topics displayed on the screen.know the code and the properties to be changed in the text box to accommodate large external file text.
View 1 Replies View RelatedIn Apex 4.2, the item validation of "Function Returning Boolean" and "Function Returning Error Text"; They seam to be backwards.
Is there a simple statement that can be used to fix this in the apex dictionary?
Is there any way to convert HTML format text to Plain Text ?
View 26 Replies View RelatedI'm new to Oracle Text. I want to implement search for the unique ids. Like google search when the user start typing 123 it need to brings anything starting with 123 and has show like entries how google will shows. When I add number 4 to like 1234 then it has bring numbers starting with 1234.
View 2 Replies View RelatedI am using Exception when others then body end;
inside the body i can get SQLCODE and SQLERRM but I also need to get the SQL statement that caused the error and I dont know how.
The following code is working fine,But the thing is if column already exists in the table,then also the other statements should be executed instead of coming out of procedure.SO how can I handle that exception??
SQL> CREATE OR REPLACE PROCEDURE sp_execparameters(tname IN VARCHAR2,
colname IN VARCHAR2,datatype IN VARCHAR2)
2 AS
3 v_sqlstr1 VARCHAR2(1000);
4 BEGIN
5 v_sqlstr1 := 'alter table '||tname||' add '||colname ||' '|| datatype ;
[code].........
1 declare
2 cursor c1 is select * from emp where deptno=&no;
3 begin
4 for i in c1 loop
5 dbms_output.put_line(i.empno||' ' || i.sal);
[code]...
PL/SQL procedure successfully completed.
SQL> /
Enter value for no: 120
old 2: cursor c1 is select * from emp where deptno=&no;
new 2: cursor c1 is select * from emp where deptno=120;
PL/SQL procedure successfully completed.
Even though deptno 120 is not there in emp table, the exception is not raising?
Is it possible to take execution control back from exception handling section to Execution statement?.. If Yes then How?..
View 25 Replies View RelatedIs it possible to get the same name of file name from imported text file?
What i've is, I import the text file then I exported it.
can I get the same name of the imported text file?
How to write an exception handler for the error "PL/SQL: ORA-01031: insufficient privilege"
View 2 Replies View Related