Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a way to check constrainte before an INSERT?
what about an on Insert TRIGGER to check the range of your values
Horst
patrik.filipsson_at_ctp.com wrote:
>
> Hi!
>
> I am currently trying do develop a database administration application in
> Powerbuilder. I'd like to know if there's a way to use Oracle's table
> constraints to make sure a user enters valid values. I'd like to not have to
> execute the INSERT before I can tell that the data was invalid. Is it
> possible to write a stored procedure or something that can look up what
> constraints there are and thereafter check the data before I even try to
> INSERT? I've found that there's a data dictionary that I could use. But,
> since not all functions in Oracle are supported in Powerbuilder it would mean
> a lot of work to try to figure out how each CHECK constraint should be tested
> in Powerbuilder. If you have any information, comments or suggestions, they
> would be greatly appreciated.
>
> Patrik Filipsson
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Sep 30 1998 - 07:21:31 CDT