Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle Functions
Message
From
14/11/2002 18:34:59
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00722984
Message ID:
00723004
Views:
21
My apologies,
after I sent the message I realized I did not say when it was giving me the error.
I pasted the code you highlighted into TOAD, (a product from Quest Software)
when I executed it, it came out with "ORA-00911: invalid character"
You think I should try from SQL Plus?


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

Click here to load this message in the networking platform