RE: Oracle PL/SQL connection through ColdFusion

[Yexley Robert D Contr AFRL/PROE]

Put the PL/SQL in the database in the form of a function, procedure or package, and then use <cfstoredproc ... /> to run it.

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

  _____  

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

The organization where I work is currently using ColdFusion 5 Enterprise on
the Windows 2000 Advanced Server platform.

We are accessing an Oracle database using an ODBC driver from Data Direct.

When I attempt to add PL/SQL commands (ex. BEGIN) I receive a message
indicating that the SQL expects SELECT UPDATE etc.

Does anybody know how to run PL/SQL in a ColdFusion environment?

Thanks,

Samson Wach
  _____

---

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

---