Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle Functions
Message
From
14/11/2002 18:23:07
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00722984
Message ID:
00722998
Views:
18
Mark,
now it gives me an "Invalid Character"


>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform