7;s more
worthwhile when you need named parameters, for one of the alternative forms
of an overloaded prodecure.
-Original Message-
From: Yexley Robert D Contr AFRL/PROE [mailto:[EMAIL PROTECTED]
Sent: Thursday, 7 October 2004 12:17
To: CF-Talk
Subject: RE: Oracle PL/SQL connection thro
rt 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 tag only supports native SQL statements only
I should have added, "if named arguments are necessary."
-Original Message-
From: James Holmes
Sent: Thursday, 7 October 2004 12:05
To: CF-Talk
Subject: RE: Oracle PL/SQL connection through ColdFusion
Calling a procedure in a built-in package without the call() syntax is onl
-Talk
Subject: Re: Oracle PL/SQL connection through ColdFusion
I think what you are trying to do, by defenition will not work, plus 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
ay, 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 tag only supports native SQL statements only
(SELECT, INSERT, UPDATE, DELETE). I don't believ
I think what you are trying to do, by defenition will not work, plus
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
It has been a very long time since I have worked with MSSQL/CF and had
to do anything special with the queries, but I seem to recall with
MSSQL you can use T-SQL in your CFQUERIES.
On Wed, 6 Oct 2004 09:09:58 -0400, Yexley Robert D Contr AFRL/PROE
<[EMAIL PROTECTED]> wrote:
> I'm not sure what you
k 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
I will give a shot.
Thank you.
>Try the Native Oracle driver in CF Enterprise, not the ODBC driver.
>
>BTW, this all works perfectly in CFMX.
>
>-Original Message-
>From: Wach, Samson [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, 6 October 2004 1:35
>To: CF-Talk
>Subject: Oracle PL/SQL con
Try the Native Oracle driver in CF Enterprise, not the ODBC driver.
BTW, this all works perfectly in CFMX.
-Original Message-
From: Wach, Samson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 6 October 2004 1:35
To: CF-Talk
Subject: Oracle PL/SQL connection through ColdFusion
The organizat
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
>
> CREATE OR REPLACE VIEW MONTHLYTOTALS AS
> SELECT *
>
>
>
> I am able
it's not PL/SQL.
// YEX //
_
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 3:12 PM
To: CF-Talk
Subject: RE: Oracle PL/SQL connection through ColdFusion
CREATE OR REPLACE VIEW MONTHLYTOTALS AS
SELECT *
I am able to run the above pl/sq
CREATE OR REPLACE VIEW MONTHLYTOTALS AS
SELECT *
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
BloodSo
Put the PL/SQL in the database in the form of a function, procedure or package, and then use 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
14 matches
Mail list logo