Unanswered: How to define an Oracle table name thru a variable
I am writing an ASP script to retrieve stock data and store it Oracle. I have been able to successfully retrieve the data and store it in one table. Now I would like to segregate the data in to multiple tables whos names are defined by the variable that holds the stock symbol.
I am using Oracle 8.1.7, Microsoft OLE DB, Win2K IIS and XP Pro.
Sincere thanks in advance for any help guidance.
Here is script I have been working with:
Function OracleWrite(TickerID, LastTrade, TradeDate, TradeTime, Change, OpenPrice, DayHigh, DayLow, Volume)
' connection and recordset variables
Dim Cnxn, strCnxn
Dim rsStocks, strSQLStockDat
Dim fld, Err
' open connection
Set Cnxn = Server.CreateObject("ADODB.Connection")