Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help calling an Oracle function
Message
De
28/02/2000 09:12:58
 
 
À
28/02/2000 08:55:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00338265
Message ID:
00338368
Vues:
16
The syntax ? indicates that the variable is a "bind variable"
see the oracle documentation for info on this it translates
to something like after the odbc driver gets its hands on it.


EXECUTE pwadm.PSINSRT(:charvar1,:charvar2,:datevar1);


Now that I think about it it may not be necessary but it has an advantage
because the oracle optimizer will not need to reparse the statement each time it
is called so it could be usefull in the case when you are calling the statement repeatedly
or often.

charvar1=""
charvar2=""
datevar=date()

lcSQL="{Call pwadm.PSINSRT(charvar1,charvar2,datevar1) }"

Should work also now that I think about it...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform