| log error feature in 10g [message #229352] |
Fri, 06 April 2007 22:03  |
elduro
Messages: 2
Registered: April 2007
|
Junior Member |
|
|
is it possible to use oracle log error feature with multitable insert?
im getting an error message
ORA-06550: line 37, column 1:
PL/SQL: ORA-00933: SQL command not properly ended
ORA-06550: line 37, column 1:
PL/SQL: SQL Statement ignored
for example
begin
INSERT ALL
WHEN (firstname IS NOT NULL AND lastname IS NOT NULL AND id IS NOT NULL) THEN
into temp1(firstname,lastname,id) VALUES(firstname,lastname,id)
WHEN (firstname IS NULL OR lastname IS NULL OR id IS NULL) THEN
INTO temp2(firstname,lastname,id) VALUES(firstname,lastname,id)
SELECT firstname,
CASE WHEN mount in (2,8,9,10) THEN lastname ELSE NULL END lastname,
CASE WHEN product_id = 4 THEN id ELSE NULL END id
FROM table1
WHEN UPPER(cat_code) <> 'GENERAL '
AND type_id <> 10
AND ind = 'Y'
LOG ERRORS INTO err$_temp('insert') REJECT LIMIT UNLIMITED ;
end;
|
|
|
|
| Re: log error feature in 10g [message #229353 is a reply to message #229352] |
Fri, 06 April 2007 22:52  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
I'm not sure why correcting syntax error requires a SQL Expert.
The lack of use of code tags make deciphering the SQL a challenge partly because I have no idea where line 37 might be.
I could be mistaken but the problem area might be
WHEN UPPER(cat_code) <> 'GENERAL '
[Updated on: Fri, 06 April 2007 22:57] by Moderator Report message to a moderator |
|
|
|
| Re: log error feature in 10g [message #229357 is a reply to message #229352] |
Fri, 06 April 2007 23:08 |
elduro
Messages: 2
Registered: April 2007
|
Junior Member |
|
|
|
i don't think this has to do with syntax error. the question is if log error feature of 10g can be use with multitable insert. the reason im getting an error is because probably it is not supported.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
