| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query works on one server, but not on another
Sorry folks, if this gets there twice. I screwed up by mail id when I
registered on the list, so replied with the wrong one.
as far as I am aware the embedded select syntax in the values list is not supported in 8.0.5.
You would need something like
insert into anc_sequences
select 101, 'test', max(trnt_id)
from
training_types;
to run on both servers
cheers
Rod
-- Rod Corderey Lane Associates RodCorderey_at_Lane-Associates.com http://www.Lane-Associates.com Jeff Wiegand wrote:Received on Thu May 04 2000 - 02:48:00 CDT
>
>
> Hey everyone,
>
> We can run this statement fine on one of our servers, but it fails on
> another:
>
> insert into anc_sequences values (101, 'test', (select max(trnt_id) from
> training_types));
>
> It returns an error:
>
> insert into anc_sequences values (101, 'test', (select max(trnt_id) from
> training_types))
> *
> ERROR at line 1:
> ORA-00936: missing expression
>
> These are identical schemas, exported and imported from one server to
> another. The only difference that I see is that it works on the server
> running 8i. The other server is 8.0.5.
>
> Any ideas?
>
> Jeff
>
> --
> Author: Jeff Wiegand
> INET: jwiegand_at_ancept.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
 |
 |