Thanks for the suggestion, but we of the Web development team do not have access to create stored procedures in the database.  We need to be able to pass the PL/SQL from the ColdFusion module.

Samson Wach

> <cfquery datasouce="#dsn#">
      
> 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]

Reply via email to