Hi Everyone:
I am using JDeveloper 10.1.3.4.0.4270 and JHeadstart 10.1.3.2.51.
I have an insert trigger that I am trying to write for an Oracle 8i table. When I insert a row using a JDeveloper/Jheadstart application, I want the code in the insert trigger to make a call to a view in a remote database that checks to see if the Financial Account inputted in the webpage is an account that actually exists. So I am not using that view in my JDeveloper application, I don't even have it declared as an entity/view. I simply want the trigger code to do a "select count(*) into Num_of_Accounts from FinanceView where finance_account = :new.account", then if the value of "Num_of_Accounts" is 0, an exception is thrown. FinanceView is a view that does a remote call to the Finance database.
When I try to insert the row in a JDeveloper/JHeadstart run (I'm in JDeveloper and right click the ViewController and select "run"), I get an internal error "ORA-01891: Datetime/Interval internal error". This same insert works fine with WINSQL on my PC.
I searched these forums looking for reference to this Oracle Error, and I only found 2 dated back to 1994 that implied this may be a bug in JDeveloper. I then searched metalink for reference to a "bug" and found nothing. Here are the forum links to the 2 references I found.
Connection to remote database problem in 9.0.4
673097
Query works in SQL but not in JDev
739898
Any and all help is appreciated.
M. Brownlie
U of Windsor