Insert command
From: Tim Slattery <Slattery_T_at_bls.gov>
Date: Fri, 19 Aug 2011 09:58:41 -0400
Message-ID: <ueqs47lc0mkgjr842kib5anl5r4mesekkq_at_4ax.com>
We're in the midst of converting a system from Sybase to Oracle. This involves converting Sybase stored procedures to Oracle procedures and functions.
Date: Fri, 19 Aug 2011 09:58:41 -0400
Message-ID: <ueqs47lc0mkgjr842kib5anl5r4mesekkq_at_4ax.com>
We're in the midst of converting a system from Sybase to Oracle. This involves converting Sybase stored procedures to Oracle procedures and functions.
We have a Sybase SP that inserts a line into a table. The syntax of the "insert" statement is:
insert into cases
values(_at_ldbNumber, @num, @submission)
The actual values list is much longer, but the interesting thing is that there is no list of columns. Apparently this is legal in Sybase.
When I run this insert statement in Oracle SQLDeveloper, I get ORA-00936: Missing Expression. Is this because there is no list of columns? Is that list required in Oracle but not in Sybase?
-- Tim Slattery Slattery_T_at_bls.gov http://members.cox.net/slatterytReceived on Fri Aug 19 2011 - 08:58:41 CDT