Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle Functions
Message
 
 
To
14/11/2002 18:23:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00722984
Message ID:
00723000
Views:
18
You need to be more specific. Is this when creating the function? If so, run the revised code below show the exact errors will be showed. Are you running this from SQL Plus?

>Mark,
>now it gives me an "Invalid Character"
CREATE OR REPLACE FUNCTION FNext
     RETURN NUMBER
   IS
     Count1 NUMBER(10);
  BEGIN
    SELECT PersonSN.nextval INTO Count1 FROM dual;
    RETURN Count1;
END;
/
SHOW ERRORS
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform