Is there a way to check constrainte before an INSERT?

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 - 05:02:23 CDT