Stephen,
What about this,
SQL Create sequence a;
SQL Create table xxx(numtest number, testvalue varchar2(100));
SQL declare
x number:=0;
begin
select a.nextval into x from dual;
Insert into xxx values(x, 'TEST');
end;
Rgrd,
Sony
: Sequences in 8.1.7 vs 9i
Stephen,
What about this,
SQL Create sequence a;
SQL Create table xxx(numtest number, testvalue varchar2(100));
SQL declare
x number:=0;
begin
select a.nextval into x from dual;
Insert into xxx values(x, 'TEST
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Thursday, January 23, 2003 2:54 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Sequences in 8.1.7 vs 9i
Stephen,
What about this,
SQL Create
: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Thursday, January 23, 2003 2:54 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Sequences in 8.1.7 vs 9i
Stephen,
What about this,
SQL Create sequence a;
SQL Create table xxx(numtest number
sed will fix that in a big hurry. PERL?! We don't need no stinkin' perl!
-Original Message-
The problem is that there are over
2000 lines of
code similar to the one I identified.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET:
:www.compuware.com
-Original Message-
Sent: Thursday, January 23, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Sequences in 8.1.7 vs 9i
Stephen,
Wild-hair idea...could you create a function with the name nextval
and use it to populate from the sequence?
Dan
I have never seen () after nextval in 7.3 or 8i or 9i .
-Bp
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 22, 2003 1:48 PM
Hello everyone.
This one stumps me and I'm wondering if it is a bug that was resolved in
9i. Here