it doesnt make much sense at all. I believe you can execute DML and
DDL through cfquery, but why would you ever want to execute PL/SQL? If
you need an IF or LOOP statement just use CF.
What benefits are you expecting from PL/SQL via cfQuery?
-Adam
On Tue, 05 Oct 2004 16:35:38 -0400, Samson Wach <[EMAIL PROTECTED]> wrote:
> 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]
