[ADFEMG-42] Check constraint parser not accepting valid constraint Created: 31/Jul/12  Updated: 28/Mar/13  Resolved: 28/Mar/13

Status: Closed
Project: adfemg
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: jflack Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: 5 days
Time Spent: Not Specified
Original Estimate: 5 days

JDeveloper, Offline Database Object modeler set for 11gR1 database.

Attachments: PNG File CheckConstraint error.png    
Tags: database, definition, object, offline, table


Entered a valid constraint (works in the database) in the Offline Database Object table definition:

Got error:
Errors parsing Check Constraint PHONE_NUM_CHK:Error(s) parsing SQL: syntax error near *Unable to render embedded object: File (* in the following *) not found.*REGEXP_LIKE(phone_num,[^[0-9]{10}


Comment by chriscmuir [ 01/Aug/12 ]

Thanks for reporting this John.

Slight correction in your text, the regular expression check constraint is: REGEXP_LIKE(phone_num,'^[0-9]



...however you have this right in the pic.

I've raised bug 14396085 on this issue.


Comment by chriscmuir [ 13/Sep/12 ]

Bug progressed internally, waiting on new fix/features from SQL Dev codeline.


Comment by chriscmuir [ 07/Nov/12 ]

SQL Dev codeline feature fixed, and imported into JDev 12.1.2 branch.


Comment by chriscmuir [ 06/Feb/13 ]

Fix is complete but need to verify if it's been submitted to the 12.1.2 JDev codeline. Contacting devs.

Comment by chriscmuir [ 06/Feb/13 ]

On speaking to the devs the fix is in the 12.1.2 SQLDev codeline and they are in the process of merging this with the 12.1.2 JDev codeline. once available I'll be in a position to test this change.

Comment by chriscmuir [ 28/Mar/13 ]

Happy to say after the code lines were merged and I had time to check, this issue is now resolved and will appear in the 12.1.2 build. As such closing this issue, but reopen if necessary.


Generated at Sun Oct 04 13:33:24 UTC 2015 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.