I'm using Oracle as my database, and Dreamweaver to create the input forms.
I need to be able to pass a value that is created automaticlly by the
database via the use of a trigger. Everything works fine when the first user
inputs his/her data, but then I get an error message after that.

Here is the trigger:
create or replace trigger wine_cust_trigger
before insert on wines
for each ro
begin
select customer_id into :new.customer_id from customer ;
end ;
/

Here is the error message:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Oracle][ODBC][Ora]ORA-01422: exact fetch returns more than requested number
of rows ORA-06512: at "LTRAUB.WINE_CUST_TRIGGER", line 2 ORA-04088: error
during execution of trigger 'LTRAUB.WINE_CUST_TRIGGER'
/phoenix/wines.asp, line 115

Any help would be appreciated.

Thanks.

"TekDragon" <TekDragon (AT) hm (DOT) com> wrote

I bet if you do
select customer_id from customer;
You will get a list of customer_ids. You can't put multiple customer_id's
into a scalar value. That is also what the Oracle error is telling you
"ORA-01422: exact fetch returns more than requested number
of rows ". I think you have limit the customer table so you choose the
correct customer.
Jim