 | |
#1
 
| |||
| |||
|
Trigger -
03-06-2008
, 05:31 AM
#2
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. Add a slash (/): |
create or replace trigger trg_i_au_clients
before insert on au_clients for each row
begin
select au_clients_seq.nextval into :new.id from dual;
end;
/
--
Regards,
Frank van Bortel
Top-posting in UseNet newsgroups is one way to shut me up
#3
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. Add a slash (/): |
create or replace trigger trg_i_au_clients
before insert on au_clients for each row
begin
select au_clients_seq.nextval into :new.id from dual;
end;
/
--
Regards,
Frank van Bortel
Top-posting in UseNet newsgroups is one way to shut me up
#4
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. Add a slash (/): |
create or replace trigger trg_i_au_clients
before insert on au_clients for each row
begin
select au_clients_seq.nextval into :new.id from dual;
end;
/
--
Regards,
Frank van Bortel
Top-posting in UseNet newsgroups is one way to shut me up
#5
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. Add a slash (/): |
create or replace trigger trg_i_au_clients
before insert on au_clients for each row
begin
select au_clients_seq.nextval into :new.id from dual;
end;
/
--
Regards,
Frank van Bortel
Top-posting in UseNet newsgroups is one way to shut me up
#6
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. Add a slash (/): |
create or replace trigger trg_i_au_clients
before insert on au_clients for each row
begin
select au_clients_seq.nextval into :new.id from dual;
end;
/
--
Regards,
Frank van Bortel
Top-posting in UseNet newsgroups is one way to shut me up
#7
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. Add a slash (/): |
create or replace trigger trg_i_au_clients
before insert on au_clients for each row
begin
select au_clients_seq.nextval into :new.id from dual;
end;
/
--
Regards,
Frank van Bortel
Top-posting in UseNet newsgroups is one way to shut me up
#8
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. Add a slash (/): |
create or replace trigger trg_i_au_clients
before insert on au_clients for each row
begin
select au_clients_seq.nextval into :new.id from dual;
end;
/
--
Regards,
Frank van Bortel
Top-posting in UseNet newsgroups is one way to shut me up
#9
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. |
corruption.
SELECT owner, object_type, COUNT(*)
FROM dba_objects
WHERE status = 'INVALID'
GROUP BY owner, object_type;
SELECT comp_name, version, status
FROM dba_registry;
What is in the alert log?
Your code works fine here though you should note that no column
should ever be named id. First because it violates database
basics ... what id? Person ID? Document ID? Passport ID? And
secondly because it is a reserved word in Oracle.
Learn this query:
SELECT keyword
FROM gv$reserved_word
WHERE keyword LIKE '%<your_string_here>%';
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#10
| |||
| |||
|
|
create or replace trigger trg_i_au_clients before insert on au_clients for each row begin select au_clients_seq.nextval into :new.id from dual; end; I have error "java.lang.IllegalArgumentException: No SQL selected for execution.Position: 0". Why can it be? Please help. |
corruption.
SELECT owner, object_type, COUNT(*)
FROM dba_objects
WHERE status = 'INVALID'
GROUP BY owner, object_type;
SELECT comp_name, version, status
FROM dba_registry;
What is in the alert log?
Your code works fine here though you should note that no column
should ever be named id. First because it violates database
basics ... what id? Person ID? Document ID? Passport ID? And
secondly because it is a reserved word in Oracle.
Learn this query:
SELECT keyword
FROM gv$reserved_word
WHERE keyword LIKE '%<your_string_here>%';
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.