CREATE OR REPLACE VIEW MONTHLYTOTALS AS
SELECT *
....
</cfquery>
I am able to run the above pl/sql query by using the oracle thin client JDBC rather then the odbc connection. You may need to update your drivers to get this kind of functionality.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
