SQL & PL/SQL :: Fail While Validating Email ID

Jul 3, 2012

I am creating function for validating email id :

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

View 8 Replies


ADVERTISEMENT

SQL & PL/SQL :: Validating Input Parameter

Aug 11, 2010

I'm using Oracle 9i. How can i check for a string if it contains only numbers or letters? Otherwise i should return false.

View 6 Replies View Related

PL/SQL :: Validating XML Against A Schema Registered In DB

Oct 2, 2012

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' ].

View 2 Replies View Related

DDL Statements Fail Or Not When DML Active?

Dec 9, 2011

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?

View 5 Replies View Related

Server Utilities :: EXP / IMP Getting Fail?

Oct 23, 2011

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:UsersAdministrator>d:
D:>imp
Import: Release 10.2.0.1.0 - Production on Mon Oct 24 08:45:48 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

[code]...

IMP-00058: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
IMP-00000: Import terminated unsuccessfully

View 10 Replies View Related

Forms :: 6i / Validating Text Items?

Nov 24, 2010

I am working on form 6i.

i need to write validation on text fields like first name,last name,phone no,email id

i have to not allow special char.

View 3 Replies View Related

Forms :: Validating Item Vehicle_Reg_No

Feb 5, 2011

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]....

View 5 Replies View Related

PL/SQL :: Validating Connection From Batch File?

Sep 3, 2012

I am trying to create a .bat file where I need to take inputs for below variables

DNAME
UNAME
PSWD
So I have done like this
SET /p DNAME="Enter the Database Name "
SET /p UName="Enter the Username "
SET /p Pswd="Enter the Password "

Now I need to validate whether I am able to establish the connection

sqlpus -s "%UName%/%Pswd%@%DNAME%"

if the above connection is valid one then perform certain action else need to echo user that Access is denied.

(ex: I am trying to say if cond is valid

stmt-1
else
echo message to user. )

View 3 Replies View Related

Clusterware :: Fail Safe Virtual IP?

Jul 3, 2012

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...

View 2 Replies View Related

Forms :: Validating Field With Data In Database?

Aug 6, 2010

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.

View 5 Replies View Related

PL/SQL :: Validating Date Without Using Inbuilt Oracle Functions

Jan 2, 2013

writing a manual date validation function without using inbuilt oracle functions.I am planning to write this function in PL/SQL.

View 17 Replies View Related

Forms :: Running Oracle Report Through 6i And Validating Between Two Dates

Feb 16, 2010

I want to call a report through forms 6i and i want to send a parameter from forms6i to report 6i. in which i want to take records between two dates.

View 26 Replies View Related

Forms :: Personalization Validating A Multi-Record Block?

Sep 5, 2012

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.

View 1 Replies View Related

Networking And Gateways :: Connect Time Fail Over?

Mar 12, 2010

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.

(DESCRIPTION_LIST =
(FAILOVER = TRUE)
(LOAD_BALANCE = FALSE)

[Code].....

View 11 Replies View Related

Forms :: WebUtil.cfg DLLs Fail To Download

Jul 14, 2011

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?

# ----------------------------------------------------------
# webutil.cfg - WebUtil configuration file
# ----------------------------------------------------------
logging.file=C:Forms_10glog_webutil.log
logging.enabled=TRUE
logging.errorsonly=TRUE
logging.connections=TRUE

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
install.syslib.location=/webutil
install.syslib.0.7.1=jacob.dll|94208|1.0|true
install.syslib.0.9.1=d2kwut60.dll|192512|1.0|true
install.syslib.0.9.2=JNIsharedstubs.dll|65582|2.0|true
[code].....

View 3 Replies View Related

JDeveloper, Java & XML :: Capture Invalid Nodes While Validating XML With Schema

Jan 6, 2011

I wonder is there any way to capture all the invalid nodes in the xml when the xml is validated with an xsd (schema).

I am using java's xml validation package to perform validation (javax.xml.validation packages in java 1.5)

View 1 Replies View Related

Bring Down The Databases In Oracle Fail Safe Environment?

Jun 28, 2013

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.

View 1 Replies View Related

SQL & PL/SQL :: Update Query Fail With Error - Missing Right Parenthesis

Feb 17, 2010

my update query seems to fail with error

ORA-00907: missing right parenthesis

Below is my test case:

create table t1(
sn varchar2(30),
inv_org number);
create table s1(
sn varchar2(30),
trx_date date,
inv_org number);

[code]...

View 8 Replies View Related

RAC/ASM Clusterware Installation :: Oracle RAC Private Connection Fail

Feb 7, 2013

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?

View 8 Replies View Related

Forms :: Created Block For Table On Tabular Style - Validating Item?

Oct 10, 2011

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.

View 16 Replies View Related

Enterprise Manager :: Client V9.2.0 Fail When Access Oracle Database 8.1.7?

May 12, 2010

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.

View 4 Replies View Related

Networking And Gateways :: Connection Fail Two Database With Identical Sid Name On Different Hosts

Feb 18, 2013

My production database server is cloned for test environnement . I kept the same name of SID for both environnement but on different hosts.

I got error when try to connect to test database : TNS:protocol adapter error.

Below the the TNSNAMES.ORA files:

----- production host ---

HOFL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol)(PORT = 1521))

[Code].....

View 10 Replies View Related

Data Guard :: Right Steps To Perform Failover In Case Primary Database Gets Fail

Jan 10, 2011

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.

View 4 Replies View Related

Installation :: Fail To Start OCR And OS / Error When Start OracleCSService

Jun 5, 2012

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".

View 3 Replies View Related

SQL & PL/SQL :: How To Get Email Address From Xml

Dec 27, 2011

I want to know how can I find/take from In parameter who is xmltype an email address ?

My function: (clob is cast to xmltype)

function submit(session_id in number, claim in clob) return xmltype

For example - I have more e-mail addresses in this:

<emails>
wtfn00b1@yahoo.com
wtfn00b2@inbox.com
wtfn00b3@mail.com
...
</emails>

I know that there is `extract` function for xml. How can I know if there is break or space between the emails ?

View 9 Replies View Related

How To Setup Email In 11g

Aug 1, 2012

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)

[code]....

View 8 Replies View Related

Getting Name In Email Address (Oracle SQL Plus)

Nov 6, 2007

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

So I how could I go about doing that?

View 2 Replies View Related

SQL & PL/SQL :: Send Email In Oracle?

Apr 24, 2013

what is the best way to send an email in oracle?

1.utl_smtp
2.utl_mail
3.utl_tcp

View 6 Replies View Related

SQL & PL/SQL :: Dbms_scehduler Email Notification

Sep 13, 2012

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?

View 6 Replies View Related

SQL & PL/SQL :: Email With Excel Attachment

Aug 4, 2011

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.

View 6 Replies View Related







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