create or replace function f_is_valid_email(p_email in varchar2) return varchar2 is
begin
if REGEXP_LIKE(p_email, '^[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+.{1}[a-zA-Z]$') then
return 'success';
ELSE
RETURN 'Failure' ;
END IF;
end f_is_valid_email;
But this function fail when
i did
SELECT f_is_valid_email('aaa..ss@AA.com') from dual
or
SELECT f_is_valid_email('aaa.ss@AA..com') from dual
I have an XML schema registered in the database (user_xml_schema table has a rows for the schema). I have another table in which XML data is stored in CLOB column.
I want to validate this XML data against the XML Schema [ SCHEMA_URL = 'MY_TEST_SCHEMA' ].
DDL statements automatically end with COMMIT the user transactions in which they appear. Foe example:
------------------------------------------- create table mytable01 (i integer); insert into mytable01 select 1 from dual; create table mytable02 (i integer); -------------------------------------------
After all three statements are executed, data are committed in mytable01.
In the Oracle DB server SQL guide we read:
"DDL commands, such as TRUNCATE, will fail if there is any DML command active on the table. A transaction will block the DDL command until the DML command is terminated with a COMMIT or a ROLLBACK."
But I executed the following without any problem:
------------------------------------------- create table mytable (i integer); insert into mytable select 1 from dual; commit; update mytable set i = 2; alter table mytable add (j integer); -------------------------------------------
So where's the truth? Are DDL statements blocked when they refer to an active object accessed from a DML or not?
I am currently having trouble validating the item Vehicle_Reg_No..I have to ensure that it starts with a letter and ends with a number. The code below gives me the TRUCK_START but for every other scenario the form throws an unhandled exception.
DECLARE TRUCK_START VARCHAR2(100); TRUCK_END VARCHAR2(100); NUM_ALERT NUMBER; BEGIN IF :M_ORDER_ITEMS.VEHICLE_REG_NO IS NOT NULL THEN truck_start := substr (:M_ORDER_ITEMS.VEHICLE_REG_NO,1,1); truck_end := substr (:M_ORDER_ITEMS.VEHICLE_REG_NO,-1,1); truck_start:= to_number(truck_start,0); truck_end := to_number(truck_end,0); [code]....
I have a Windows 2008 R2 SP1 2 node active/passive cluster with fail safe 3.4.2 installed. I also have 11G database software installed. My problem is I am unable to successsfully add an oracle virtual IP to the oracle group within fail safe. I receive the below error when I try. I need to get this resolved so that I can add my databases to the cluster.
Oracle Fail Safe Manager
FS-10890: Oracle Services for MSCS failed during the create operation FS-11220: Failed to create the virtual address FS-10012: Failed to bring the cluster resource Network Name HHVHAVELP01 online. Check the Windows event log for messages. FS-10726: Resource Network Name HHVHAVELP01 is in a failed state
I don't see any message in the event log when I check...
I currently have a field in which the user inputs a number, but before this number is allowed to be saved to the database it has to be checked to see if the number is already stored in a different field within the database. For example, if the number is not in the database the user cannot put that number into the field.
I do want it to be user input so I don't want a LOV linked to the appropriate field in the database.
Is below anyway close to the way it should be done? For some reason seq_rec.seq seems to give me 3 and doesn't seem to compare it with each of the values in the database.
DECLARE cursor seq_curs IS SELECT SEQ FROM ZZJOB; seq_rec seq_curs%rowtype; none_existing_seq EXCEPTION; invalid_seq EXCEPTION; return_alert NUMBER;
[code]....
Just say the field in my database has numbers: 1 2 3 4 and 5 in the field that i allow the user to input data they can only enter 1 2 3 4 or 5. Hence the check needs to be made with te database field to check if the input number is already in the database.
P.S. they are separate fields for different things, the numbers just need to be in one field before they can be added in the other.
I have a problem validating a multi-record block. I need to put the validation after the user clicks save. The custom validation should run through all the records in the multi-record block. But instead of validating all records, it will only validate the record where the cursor is located before the user hits save.
I would like to implement connect time fail over from my JDBC thin client. The client will try to first connect with dedicated connection mode, if the connection time crosses more than two seconds, then connection will be opened with shared mode. To implement this, I have put the following connection string in my JDBC URL. I am able to connect to database with this URL, however it seems fail over does not work. Is it because, my database listener is not configured with dynamic service registration. If I implement the dynamic service registration, is fail over going to work? Note, I want to fail over in the same database instance but with different listener.
I have set up a number of other developers on the team, using the same configuration setup which performs without error. We have the ORCALE Forms on our local PC, and have been testing them successfully.
We are using Forms Version 10.1.2.0.2, Oracle Database 10g Release 10.2.0.4.0, OS is Windows XP Pro SP3
We are currently using JInitiator 1.3.1.22, but will be using the Java plug in in a later release of our code. I have been making code modifications and testing for a number of months on the PC. To log into our application the dlls must first be downloaded onto the client PC from the web server. Tuesday morning a problem occured. I had modified the webutil.properties to get the DLLs to download again in assisting another developer in researching a problem he was having. Now the three files jacob.dll, d2kwut60.dll, JNIsharedstubs.dll fail to download at all, causing an error almost from the start in the application. The download dialog box does not display for these nor are they found then in the webutil.properties or JInitiator directory.
The user DLL's dds_lFileUtil.dll, dds_lcac.dll, DDS_lExtProc.dll download successfully, but the webutil.properties fails to update for the third dll, causing the missing dll to continue to download upon each time the application starts. This is evident from the download dialog box being visible, and the dll being found in the JInitiator directory.
I have read that you should be able to copy the DLL to the correct directory (JInitiator directory) and manually update the webutil.properties and then the functionality should work. However this is not true for us, the functionality still fails to log in successfully.
I included the WebUtil file below with commented lines removed for ease of reading. The formsweb.cfg is pointing to the env which points to the WebUtil.cfg correctly.
We are administrators on our PC's.
The questions: 1) Why are jacob.dll, d2kwut60.dll, JNIsharedstubs.dll failing to download? 2) Why is the third file not being written to the webutil.properties?
How can we bring down the databases in oracle fail safe environment?
We have one database X in two server�s windows A & B with oracle fail safe environment. What procedure should we fallow to bring down the database X.
Today I was strangling to bring down the database because database was automatically coming up once brought down the database. what procedure should we follow to bring down the database in OFS environment.
I would like to know that when the private network in oracle rac down, which is the preferable node in the cluster (cluster of 2 nodes) to takeover the cluster.
Can I set/get the failover policy to point to one node in the cluster?
I created a block for EMP table on tabular style. if in first line empno entered is 1then i don't want to allow the end user to enter 1 in second line. but when-validate-item is not working because first_record and next_record is not allowed. I need to validate before saving the data into emp table and immediately after empno is entered into empno item.
behaviour of oracle enterprise manager. i want to edit a table of a database. after i clicked on the table the oem crashes without any messages - simply disappearing.
i installed oracle9i release2 V9.2.0.1.0 windows client and want to access an oracle8i V8.1.7 server on linux.
i have Oracle 10g data guard set up on windows environment.....i need to know the what are the right steps to perform failover in case the primary database gets fail.
I'm trying to install Oracle 10g Enterprise Ed. (on Windows 2003 Std. Ed) and I get some errors:
First “Fail to start OCR” I press "continue" and the installation continue. Next “Operative System Error when start OracleCSService” and when I press "continue" the installation finish.
At the end of installation, It seems like Oracle DB is Ok, but not really...I can't connect to database from Enterprise Manager and the OracleCSService is in "Starting mode".
I migrated a server + data + APEX application from 10g to 11g. Now my email sending is all messed up because of the ACL in 11g. I can't seem to figure out how to appease it. I have the smtp server correctly set in the parameters. Here is the procedure I'm trying to use (from [URL]):
CREATE OR REPLACE PROCEDURE send_email( pFromUser IN VARCHAR2, pToUser IN VARCHAR2, pSubject IN VARCHAR2 DEFAULT NULL, pBody IN VARCHAR2 DEFAULT NULL)
How do I select the name in an email address. I would like to be able to order a list of email addresses by the name of the person ie. what comes before the @ sign.
So is there a query I could use to get everything before the at line . So in pseudocode I would need to be able to do something like this.
select substr(email, indexOf(@)+1,email.length) from table order by email
I have set up my dbms_scheduler schedule and all run fine. I have set up the smtp server for outgoing email and it all looks good just like multiple of our other boxes here.The problem is that the event (SUCCESS) for a job is raised yet the email notification is not sent. My question is this: Is there somewhere where the actual log of email notifications sent (and/or failure there-of) is actually kept?
I need the pl/sql procedure that sends email with excel attachment using utl_smtp.The email procedure should take the excel attachment file from my local directory.