Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement