usually does it. Another variation on that them that typically works is:
select * from t, ( select pkg.function_name PKG_VALUE from dual )
where t.column_name = pkg_value
(join to the function instead of comparing to it).
In Oracle8i, release 8.1 there are "deterministic" functions (see
http://osi.oracle.com/~tkyte/article1/index.html for example usage) as well.
Also, in Oracle8i, release 8.1 they've added a feature called application
contexts. See http://osi.oracle.com/~tkyte/article2/index.html for example uses
of that. Basically, with an application context -- I can put values into a
named context and then use them in queries. for example:
select * from t
where column_name = sys_context( 'Name_Of_My_context',
that query will be rewritten in effect as:
select * from t where column_name = :bind_variable
and the sys_context function will be evaluated once per query, not once per row.
Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation
i got my DTS Package working. i did this in my vb code.
oPKG.LoadFromSQLServer "TBSSDB", "sa", "", DTSSQLStgFlag_Default, , , ,
"Upload TBSS Budget"
oPKG.GlobalVariables("sFileName").Value = Trim(txtFileName.Text)
oPKG.GlobalVariables("sTableName").Value = Trim(xlsString)
oPKG.GlobalVariables("sHeaderName").Value = Trim(HeaderString)
the sFileName, sTableName, sHeaderName doesn't change
in my dts package properties. how do i reset these values
as i need the package to work for different text files?
oPKG.GlobalVariables("sFileName").Value = " "
oPKG.GlobalVariables("sTableName").Value = " "
oPKG.GlobalVariables("sHeaderName").Value = " "
but it didnt work.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
10. package variable