RE: Oracle PL/SQL connection through ColdFusion

[Yexley Robert D Contr AFRL/PROE]

I'm not sure what you're attempting to do is possible then. I'm fairly certain that the <cfquery> tag only supports native SQL statements only (SELECT, INSERT, UPDATE, DELETE). I don't believe it supports proprietary procedural code such as PL/SQL or Transact-SQL. I don't think even CFMX supports that. Maybe there's a different tag that allows it, but if so, I'm not aware of it. Sorry.

================
// YEX //

  _____  

From: Samson Wach [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 4:36 PM
To: CF-Talk
Subject: Re: Oracle PL/SQL connection through ColdFusion

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]

---