Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle Functions
Message
 
 
To
14/11/2002 17:56:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00722984
Message ID:
00722988
Views:
22
Try this instead:
   CREATE SEQUENCE PersonSN
   INCREMENT BY 1
   START WITH 100001
   NOCACHE;

   ** Create a Server Function "FNext" to return the next sequence from
   ** Person.

   CREATE OR REPLACE FUNCTION FNext
      RETURN NUMBER
    IS
      Count1 NUMBER(10);
   BEGIN
      SELECT PersonSN.nextval INTO Count1 FROM dual;
    RETURN Count1;
   END;
   /

>
>Select FNext from dual
>
>
>Thanks for your help
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform