Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle Functions
Message
De
14/11/2002 17:56:18
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Oracle Functions
Divers
Thread ID:
00722984
Message ID:
00722984
Vues:
65
Oracle experts,
I need to know how to create a function and then how to call it.
I tried a couple of things and did not give me any errors but neither it created it. I copied
For now I want to find out how to do it from TOAD later on I will do it from VFP.
this is what I tried from MS site and did not work:

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,2);
BEGIN
SELECT PersonSN.nextval INTO Count1
FROM dual;
RETURN(Count1);
END;
/
		

Select FNext from dual


Thanks for your help
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform