General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only