RE: Oracle PL/SQL connection through ColdFusion

[Yexley Robert D Contr AFRL/PROE]

Would you be able to provide a code sample of an anonymous PL/SQL block within a <cfquery> tag? Particularly one that requires arguments if possible. I'd be interested in seeing an example of that approach, as I've never seen any sort of documentation on how to implement this. I think that's exactly what the original message was requesting as well, so I think it would help a number of people out. Thanks very much for straightening me out.  ;)

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

  _____  

From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 12:01 PM
To: CF-Talk
Subject: RE: Oracle PL/SQL connection through ColdFusion

CFMX does indeed support it as I've used it myself (as a quick test of some
code). Of course I then created the procedure in an Oracle package, but it
still worked in a standard cfquery.

-----Original Message-----
From: Yexley Robert D Contr AFRL/PROE [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 6 October 2004 9:10
To: CF-Talk
Subject: RE: Oracle PL/SQL connection through ColdFusion

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.
  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---