Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
- Original Message -
From: jon hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 3:02 PM
Subject: cfstoredproc code generator
Does a free one
perfect for what it is.
However, I'm looking for more of a tool that will take the SQL, or
connect to the data source directly and generate the cfstoredproc.
It's the repetitive typing I'm trying to get around...
I just wrote a little snippet to parse the SP varnames and datatypes
after I posted
:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 4:40 PM
To: CF-Talk
Subject: Re: cfstoredproc code generator
Thanks! This was what I had seen.
Three things:
It should allow more than 20 parameters.
Those stock images with the people shot from the overhead view are a
pet peeve of mine
It't not just an occasionaly thing, it's with _every_
cfstoredproc call.
Updating MDAC ( while not necessarily a bad idea ) won't
help, because the
The specific error that Andy was getting can be related to
the version of
MDAC that is installed on the server.
Ahh... well -- he mentioned
I'm pretty sure it's the order that is hanging it up. I have used
cfstoredproc in other places on our servers and it works just fine.
It's pretty dissapointing that this seems to be a feature or bug or
whatever you want to call it that MM is ignoring. What happens when you
want to skip
I'm pretty sure it's the order that is hanging it up. I
have used
cfstoredproc in other places on our servers and it works
just fine.
It's pretty dissapointing that this seems to be a
feature or bug or
whatever you want to call it that MM is ignoring. What
happens when you
want to skip
19, 2002 7:20 AM
To: CF-Talk
Subject: RE: cfstoredproc behavior
I'm pretty sure it's the order that is hanging it up. I
have used
cfstoredproc in other places on our servers and it works
just fine.
It's pretty dissapointing that this seems to be a
feature or bug or
whatever you want
this behavior?
Andy
-Original Message-
From: S. Isaac Dealey [mailto:info;turnkey.to]
Sent: Saturday, October 19, 2002 7:20 AM
To: CF-Talk
Subject: RE: cfstoredproc behavior
I'm pretty sure it's the order that is hanging it up. I
have used
cfstoredproc in other places on our
Yes, I have run the updater, but the stored procedure worked before the
updater as well.
-Original Message-
From: S. Isaac Dealey [mailto:info;turnkey.to]
Sent: Saturday, October 19, 2002 12:09 PM
To: CF-Talk
Subject: RE: cfstoredproc behavior
Have you run the MX Updater? They may haved
Dealey [mailto:info;turnkey.to]
Sent: Saturday, October 19, 2002 12:09 PM
To: CF-Talk
Subject: RE: cfstoredproc behavior
Have you run the MX Updater? They may haved worked around
the issue with the
JDBC drivers in the updater.
Yes, many of my stored procedures return recordsets
Have you run the MX Updater? They may haved worked around
the issue with the JDBC drivers in the updater.
Based on my reading of the log file created by the Updater, no database
drivers were changed by the update process.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202)
I have a dynamic query that I was trying to use the cfstoredproc tag with,
but all I kept getting was the generic Unknown data access error. So I
re-wrote it with cfquery and it works fine, but I can't see any difference
in the two. Can anyone here see why the cfstoredproc version wouldn't
work
Trying using CF_SQL_TIMESTAMP for the date fields.
- Original Message -
From: Andy Clary [EMAIL PROTECTED]
Date: Friday, October 18, 2002 10:19 am
Subject: cfstoredproc behavior
I have a dynamic query that I was trying to use the cfstoredproc
tag with,
but all I kept getting
feature in cfstoredproc/cfprocparam which causes it to completely ignore
the parameter names. This could especially be an issue with your cfoutput
at the end of your cfstoredproc call if there are any parameters missing,
or if they aren't in exactly the same order. !--- I've dealt with this hell
a lot
The parameters aren't in the same order as in the
stored procedure, but is there any way to get
around this feature. That sounds like a severe
limitation of the tag. I'd rather not have to put
the parameters in order, that is what the dbvarname
attribute is for. Does this happen all the
Does Macromedia know this is a bug?
Macromedia is aware of this behavior, since it was specifically mentioned in
the old ACFD curriculum, if I recall correctly. I don't know if it's their
issue, or a problem with the database drivers, which are supplied by
DataDirect.
Was this corrected in
Does Macromedia know this is a bug? Was this corrected in CFMX?
-Original Message-
From: Dave Watts [mailto:dwatts;figleaf.com]
Sent: Friday, October 18, 2002 2:52 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: cfstoredproc behavior
The parameters aren't in the same
Do you know what version of MDAC is on the server?
-Original Message-
From: Andy Clary [mailto:aclary;teleplanwireless.com]
Sent: Friday, October 18, 2002 2:08 PM
To: CF-Talk
Subject: RE: cfstoredproc behavior
Isaac,
Thanks for the info, and to the previous poster
I believe it is version 2.6
-Original Message-
From: Kwang Suh [mailto:ksuh;shaw.ca]
Sent: Friday, October 18, 2002 3:04 PM
To: CF-Talk
Subject: RE: cfstoredproc behavior
Do you know what version of MDAC is on the server?
-Original Message-
From: Andy Clary [mailto:aclary
Was this corrected in CFMX?
Honestly, I haven't tested to find out.
I ran the CFMX Code Analyzer against an old app last night and one of the
things it mentioned was that dbvarname is ignored in CFMX and that
parameters must be listed in proper order.
Ken
proc:
create procedure
@a int,
@b int
as
select @a as a, @b as b
go
Write out a cfstoredproc tag with the cfprocparam tags in the right order
and output the results. Then reverse the order of the parameters and do the
same.
It't not just an occasionaly thing, it's with _every_
It't not just an occasionaly thing, it's with _every_ cfstoredproc call.
Updating MDAC ( while not necessarily a bad idea ) won't help, because the
The specific error that Andy was getting can be related to the version of
MDAC that is installed on the server
PROTECTED]]
Sent: 30 September 2002 02:34
To: CF-Talk
Subject: more cfstoredproc issues ...
Argh!
I have a stored procedure with parameters as:
CREATE PROCEDURE tap_adLibUpdate
@LibraryID int,
@Ident int,
@UpdatedDate datetime,
@PageFileName varchar(15) = NULL
and not your CF.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: 30 September 2002 02:34
To: CF-Talk
Subject: more cfstoredproc issues ...
Argh!
I have a stored procedure with parameters as:
CREATE PROCEDURE tap_adLibUpdate
@LibraryID int
having the
problem was using CFMX and M$SQL. Hope this helps you out and that I didnt
misunderstand that whole think last week.
Josh
-Original Message-
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 7:31 AM
To: CF-Talk
Subject: RE: more cfstoredproc issues
Thanks for the suggestion josh. I didn't think I had used any cf_sql_date
flags... I did a search and replace on wwwroot including subfolders just to
be sure and it didn't replace anything, so...
I do not know if this may be the underlying cause of the
error but I do know
that if sql is your
Figured it was a long shot, but I tried it -- no dice. Thanks for the
suggestion Ade,
Whenever I right an SP I use..
CREATE PROCEDURE someSP
somthing AS int,
somethingelse AS varchar(50)
I don't know if not using the AS is ok or not but give it
a go, see if it fixes it
.
-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 29, 2002 6:34 PM
To: CF-Talk
Subject: more cfstoredproc issues ...
Argh!
I have a stored procedure with parameters as:
CREATE PROCEDURE tap_adLibUpdate
@LibraryID int,
@Ident int
-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 29, 2002 6:34 PM
To: CF-Talk
Subject: more cfstoredproc issues ...
Argh!
I have a stored procedure with parameters as:
CREATE PROCEDURE tap_adLibUpdate
@LibraryID int,
@Ident int,
@UpdatedDate
version...
-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 9:36 AM
To: CF-Talk
Subject: RE: more cfstoredproc issues ...
Dude... In your cfprocparam tag, you write this: cfprocparam
type=in dbvarname=LibraryID
You should write
the wrong var name just switches to the first
version...
-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 9:36 AM
To: CF-Talk
Subject: RE: more cfstoredproc issues ...
Dude... In your cfprocparam tag, you write this:
cfprocparam
this code:
cftry
cfoutput!-- some content --/cfoutput
cfstoredproc procedure=tap_adLibUpdate datasource=#request.tap.dsn#
username=#request.tap.dsnusr# password=#request.tap.dsnpwd#
cfprocparam type=in dbvarname=LibraryID
value=#variables.PageID
didn't help huh...
-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 11:13 AM
To: CF-Talk
Subject: RE: more cfstoredproc issues ...
Actually the names in the dbvarname attribute are completely ignored by the
cf-server as far as I
: S.Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 11:13 AM
To: CF-Talk
Subject: RE: more cfstoredproc issues ...
Actually the names in the dbvarname attribute are completely ignored by
the
cf-server as far as I or anyone else has been able to determine. They have
,
UpdateError varchar(8000) = NULL
AS
and I'm using this code in CF:
cfstoredproc procedure=tap_adLibUpdate datasource=#request.tap.dsn#
username=#request.tap.dsnusr# password=#request.tap.dsnpwd#
cfprocparam type=in dbvarname=LibraryID value=#variables.PageID#
cfsqltype
automatically
converts the Char into a date object - as long as the format is correct.
-mk
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 8:52 PM
To: CF-Talk
Subject: Re: more cfstoredproc issues -- ARGH!!
The other thing that really
S. Isaac Dealey wrote:
Yea, it turned out to be the cf_sql_date that was causing the wrong number
of parameters error message... so changing that to cf_sql_timestamp solved
the problem... Better support for cfstoredproc ( naming and better error
handling in particular. ) would be _great_
S. Isaac Dealey wrote:
Yea, it turned out to be the cf_sql_date that was causing
the wrong number
of parameters error message... so changing that to
cf_sql_timestamp solved
the problem... Better support for cfstoredproc ( naming
and better error
handling in particular. ) would be _great_
A couple of things to note about using cfstoredproc with MX:
First, passing parameters in the order in which they are specified is
required in JDBC. In previous versions of CF that used ODBC, you were
supposed to be able to use named notation - althought from what I
understand, this never
I wasn't saying it was just a kludge. I was saying that it STARTED as a
kludge. Remember, it was sort-of half-finished and non-documented in CF4.5.
I never said it wasn't useful. I think CFQUERYPARAM is fantastic. I
user it in all inline queries; I wouldn't dream of dropping a CF
variable
Joe, can you give an example of how you're using call or exec to run your
stored procedures, and info on what database you're using. Does that
approach only work when there are no out parameters, or are those still
returned?
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
Joe,
I'll have to check that out for myself. What db platform are you on?
-mk
-Original Message-
From: Joe Eugene [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 9:46 PM
To: CF-Talk
Subject: RE: cfstoredproc and CF MX
Mark,
I have been writing Stored Procedures
!---
@inputParam1... are the input variables declared in your procedure ---
/cfquery
From my Experience, the above 2 ways run faster than
cfstoredProc. The only downside is
you cannot capture multiple RecordSets from the Procedure..
using a CALL or EXEC
Well, it works for me. I'd just check your code out. That was
production-level code I used as an example, so I'm 110% certain it works.
As for your comments... yeah it's stupid. But without knowing exactly
what CFSTOREDPROC does, what's to say?
At any rate, I avoid that issue
SQL Server 2k and 7.0
Joe
- Original Message -
From: Mark A. Kruger - CFG [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 04, 2002 9:50 AM
Subject: RE: cfstoredproc and CF MX
Joe,
I'll have to check that out for myself. What db platform are you on?
-mk
I knew there were reasons I had avoided using cfstoredproc prior to
ColdFusion MX ...
So with the advent of MX and not wanting to force my clients / customers to
use the odbc bridge drivers, I decided to convert all of my exec sp_myproc
syntax in cfquery tags to cfstoredproc tags and after
Also, although the documentation for cfprocparam says the attribute
null= takes a boolean, yes/no value, it does not -- it takes no value
and
passes null regardless of any value given.
Not mine. Null takes Yes/No as legal values. Use it all the time.
CF4.5.1SP2, Spectra 1.01, Oracle 8i
Sorry you weren't aware of the ordering issue. It often makes me
wonder what CFSTOREDPROC is really doing, aside from invoking a
platform-specific call to an SP...
At any rate, the way I deal with null/not null situation is this:
cfprocparam type=In cfsqltype=CF_SQL_CHAR dbvarname=ctcd
Sorry you weren't aware of the ordering issue. It often
makes me
wonder what CFSTOREDPROC is really doing, aside from
invoking a
platform-specific call to an SP...
At any rate, the way I deal with null/not null situation
is this:
cfprocparam type=In cfsqltype=CF_SQL_CHAR
dbvarname
I tested some CFStoredProc stuff calling it multiple times and calling the
stored procedure multiple times with a CALL{ } Statement. CFStoredProc
ran slower about 100-200 milliseconds... I dont see a reason to use
CFStoredProc
unless u are returning more than 3-5 resultsets at a time..
Joe
Joe,
When using stored procs, a lot depends on what you are doing inside of it -
and just like CF code, it has to be optimized for performance. Also, using
cfstoredproc will give you the same benefits as cfqueryparam, so it
should be used (where possible) instead of directly calling the proc
cfquerparam less
code...--
When i ran the same SP using CALL and cfstoredProc...
the CALL statement scaled/ran better... am not sure.. why CFStoredProc
runs slow or how it is implemented..
Joe
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 1:48 PM
To: CF-Talk
Subject: RE: cfset/cfstoredproc
Janine,
I don't think I'm following your example. What's wrong with the second
example? also, why do you need 2 queries? Why
This is somewhat of a repost from the other day but haven't gotten any
feedback- since I don't think I worded my problem very well.
I am moving some of my work from cfquery to storedprocedures- the problem is
the formatting when I use cfset with a stored procedures- they don't react
the same way
Janine,
I don't think I'm following your example. What's wrong with the second
example? also, why do you need 2 queries? Why not a join? a join would give
you columns of
name , answer
name, answer,
name, answer
name, answer
ORder by name and make sure there is a PK ... then do this:
cfoutput
Sorry about this stupid question.
if i put debug=Yes inside cfstoredproc, where am I going to see the
debug info? How am I going to see the cfstoredproc debug info just like
what cfquery shows (record numbers, time, etc)?
Thanks
J
knows that I'm clueless! Thanks!
Gary 8-)
- Original Message -
From: Kwang Suh [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 3:21 PM
Subject: RE: CFStoredProc cfsqltype=cf_sql_Date doesn't work with
SmallDateTime SQL Type...Why?
Try using
When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a
SmallDateTime SQL field, I get an error...why?
ERROR MESSAGE RECEIVED:
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error,
COLDFUSION CODE
PROTECTED]]
Sent: Thursday, February 07, 2002 12:38 PM
To: CF-Talk
Subject: CFStoredProc cfsqltype=cf_sql_Date doesn't work with
SmallDateTime SQL Type...Why?
When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a
SmallDateTime SQL field, I get an error...why?
ERROR MESSAGE RECEIVED
Try using CF_SQL_TIMESTAMP.
-Original Message-
From: Gary Ashbaugh [mailto:[EMAIL PROTECTED]]
Sent: February 7, 2002 12:38 PM
To: CF-Talk
Subject: CFStoredProc cfsqltype=cf_sql_Date doesn't work with
SmallDateTime SQL Type...Why?
When I use cf_sql_Date for the cfsqltype with in my
stored proc is definately faster because everytime you use
cfquery, the sql inside the tag has to be interpreted to the
language the dataserver understands...with cfstoredproc this
step is skipped.
The problem with generalizations is that they're usually not always correct.
That's true
To: CF-Talk
Subject: Re: CFStoredProc vs CFQUERY
Thanks for the info, does anyone know if one is faster than the
other?
Steve
- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 21, 2002 8:29 PM
Subject: RE: CFStoredProc vs
stored proc is definately faster because everytime you use cfquery, the sql
inside the tag has to be interpreted to the language the dataserver
understands...with cfstoredproc this step is skipped.
At 06:42 PM 1/29/2002 -0500, you wrote:
Do not know about speed, but access to output
: Justin Greene
To: CF-Talk
Sent: 1/29/02 6:42 PM
Subject: RE: CFStoredProc vs CFQUERY
Do not know about speed, but access to output parameters and the
ability to
trap an error (i.e. detect that an error code was returned) are in
themselves worth it.
Justin
-Original Message-
From: Steven
I was just wondering if any one knew the difference between the
following:
CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO
dbVarName = @param2
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER VARIABLE =
BAR dbVarName
To access results from a cfstoredproc you would use
cfstoredproc procedure=usp_myproc datasource=dns
cfprocresult name = query_name resultSet = n maxRows =
maxrows
cfprocparam .
/cfstoreproc
Whenever I use a stored procedure I call it with a cfquery.
I'm not sure
I was just wondering if any one knew the difference between the
following:
CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO
dbVarName = @param2
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER VARIABLE =
BAR dbVarName
Use the CFPROCRESULT name=MyQueryObject inside the CFSTOREDPROC
tags
(normally the last one specified)...
Using cfstoredproc tags eliminates a bunch of errors - in the CFQuery
call,
how do you know the Date is a proper format? the cfprocparam tags
handle
any neccessary conversion (within
Thanks for the info, does anyone know if one is faster than the other?
Steve
- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 21, 2002 8:29 PM
Subject: RE: CFStoredProc vs CFQUERY
Use the CFPROCRESULT name=MyQueryObject
You can only call stored PL/SQL procedures from Oracle using CFSTOREDPROC
, not
stored PL/SQL functions. Also, RETURNCODE has to be no for Oracle.
Regards,
Joel Parramore
-Original Message-
From: Eric Gilbert [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 11:42 PM
I also seem to remember that returncode=yes will throw things. Try taking
that out.
cfstoredproc procedure = s_departement_get_all dataSource=
#request.db.dsn# returnCode = Yes cfprocparam type = Out
CFSQLType = CF_SQL_REFCURSOR variable=
testingoutvar cfprocresult name = rs1 maxrows=-1
1, column 7: PL/SQL
Statement ignored
the CF code is:
cfstoredproc procedure = s_departement_get_all dataSource =
#request.db.dsn# returnCode = Yes
cfprocparam type = Out CFSQLType = CF_SQL_REFCURSOR variable =
testingoutvarcfprocresult name = rs1 maxrows=-1
/cfstoredproc
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 14, 2002 11:41 PM
Subject: Oracle 8i and cfstoredproc confusion
Hi all, I've gotten my self twisted around on the correct way get a res
ult
set back from an oracle 8i procedure . This is my first real attemp
t
at
this and based
PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Oracle Stored Procedure and cfstoredProc
Date: Thu, 13 Dec 2001 14:22:34 -0500
All,
Is it possible to pass a parameter into an Oracle Stored Procedure to
limit the record set that is returned but the procedure
want a return a set of records.
I appears that it is not possible to supply additional values to
CFstoredproc when trying to retrieve a record set.
I have the cfstoredproc tag defined as follows:
cfstoredproc
procedure=Portfolio.Get_Branch
datasource=#Application.DSN
, it works fine. But
I do not want all the records. I just want a return a set of records.
I appears that it is not possible to supply additional values to
CFstoredproc when trying to retrieve a record set.
I have the cfstoredproc tag defined as follows:
cfstoredproc
procedure
to
CFstoredproc when trying to retrieve a record set.
I have the cfstoredproc tag defined as follows:
cfstoredproc
procedure=Portfolio.Get_Branch
datasource=#Application.DSN#
dbtype=#Application.DSNDBType#
cfprocparam type=In cfsqltype=CF_SQL_INTEGER
that is returned but the procedure? If I remove
the IN Parameter from the Oracle Stored Procedure, it works
fine. But
I do not want all the records. I just want a return a set of records.
I appears that it is not possible to supply additional values to
CFstoredproc when
that it is not possible to supply additional values to
CFstoredproc when trying to retrieve a record set.
I have the cfstoredproc tag defined as follows:
cfstoredproc
procedure=Portfolio.Get_Branch
datasource=#Application.DSN#
dbtype=#Application.DSNDBType#
cfprocparam type=In cfsqltype
and cfstoredProc
Date: Thu, 13 Dec 2001 14:22:34 -0500
All,
Is it possible to pass a parameter into an Oracle Stored Procedure to
limit the record set that is returned but the procedure? If I remove
the IN Parameter from the Oracle Stored Procedure, it works fine. But
I do not want all the records. I
CFSTOREDPROC PROCEDURE=ASTDTCCK.TESTPRC14 DATASOURCE=ork DEBUG=Yes
CFPROCPARAM TYPE=IN cfsqltype=CF_SQL_CHAR VALUE=12345678
variable=dealer_number
CFPROCPARAM TYPE=INOUT cfsqltype=CF_SQL_CHAR VALUE=ABCDEFG
variable=price
/CFSTOREDPROC
The above stored proc works against the AS400. How
Can you not do it any other way?
-Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 7:59 AM
To: CF-Talk
Subject: AS400 Stored Procedure without using CFSTOREDPROC?
CFSTOREDPROC PROCEDURE=ASTDTCCK.TESTPRC14 DATASOURCE=ork DEBUG=Yes
-Talk
Subject: RE: AS400 Stored Procedure without using CFSTOREDPROC? -
Anyone?
Can you not do it any other way?
-Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 7:59 AM
To: CF-Talk
Subject: AS400 Stored Procedure without using
Trying to get a stored proc on to run that will retrieve a CLOB. Oracle 8,
CF 4.5.1 service pack 2.
CLOBS work with insert, update, select but when I try to call a stored
procedure using this param
cfprocparam type = Out cfsqltype = CF_SQL_CLOB variable = copy
dbvarname = o_copy
I throws the
Hello folks,
I'm trying to call an Oracle stored procedure (a PL/SQL function) from
ColdFusion using CFSTOREDPROC and have been unable to do so. When I call
the function, I get the following error:
Oracle Error Code = 6550
ORA-06550: line 1, column 7: PLS-00221: 'FSELECTSTATE
Had a strange error on a page that's been bug-free and
unmodified for months. It uses CFSTOREDPROC ...
i recommend you avoid this tag if possible.
Why is that?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
PROTECTED]
-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 7:00 PM
To: CF-Talk
Subject: CFSTOREDPROC error
Hi all,
Had a strange error on a page that's been bug-free and unmodified for
months
Hi all,
Had a strange error on a page that's been bug-free and unmodified for months. It
uses CFSTOREDPROC, which I haven't used much in the past, so I thought I'd throw
it to CF Talk.
Unknown Data Access Error.
The error occurred while processing an element with a general identifier
You may want to show a copy of your code.
There's probably a typo or something. The sproc is not even being executed
yet.
-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 7:00 PM
To: CF-Talk
Subject: CFSTOREDPROC error
Hi all,
Had
i recommend you avoid this tag if possible.
At 01:59 PM 7/6/01 +1200, you wrote:
Hi all,
Had a strange error on a page that's been bug-free and unmodified for
months. It
uses CFSTOREDPROC, which I haven't used much in the past, so I thought I'd
throw
it to CF Talk.
Unknown Data Access Error
Thanks Aaron.
DTS was my first attempt but it will not work on this shared server with a
text file.
Regards,
Marc Garrett
- Original Message -
From: Aaron Rouse [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 9:58 PM
Subject: Re: CFSTOREDPROC
=ColdFusion
- Original Message -
From: Marc Garrett [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 6:34 AM
Subject: Re: CFSTOREDPROC and performance question
Thanks Aaron.
DTS was my first attempt but it will not work on this shared server with a
text file
into the database, the query takes about 160 to
200 seconds to complete. In an effort to boost performance, I wrote a stored
procedure in SQL Server and called it via CFSTOREDPROC from CF. But the sp takes
about 183 to 185 seconds to execute.
Is this expected? Am I better off trying a query
: Jon Hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 8:22 PM
Subject: Re: CFSTOREDPROC and performance question
How about using BCP?
cfquery name=InsertInitial DATASOURCE=#DSN# USERNAME=#user#
PASSWORD=#pass#
BULK INSERT Table
FROM 'D:\FR\FileResource\101-200
takes about 160 to
200 seconds to complete. In an effort to boost performance, I wrote a stored procedure
in SQL Server and called it via CFSTOREDPROC from CF. But the sp takes about 183 to
185 seconds to execute.
Is this expected? Am I better off trying a query that simply calls the sp instead
I have a problem trying to call a stored procedure in
Oracle 8i using CFSTOREDPROC. My code for the sp is
below (followed by my cf code):
CREATE OR REPLACE PACKAGE WebInterface
AS
PROCEDURE IsBaseCaseComplete (p_CaseID IN NUMBER,
p_Complete OUT VARCHAR2);
PRAGMA RESTRICT_REFERENCES
Try
CFSTOREDPROC procedure=WebInterface.IsBaseCaseComplete
and the rest as you have it.
-Original Message-
From: Andrew Middleton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 9:17 AM
To: CF-Talk
Subject: Oracle 8i and CFSTOREDPROC
I have a problem trying to call a stored
What is the best way of handling the following situation.
I have 3 stored procedures I want to call from coldfusion and once all 3 have executed
sucessfully, I want to commit them, if any fails, I want to do a rollback.
Can this be done with cftransaction or is that only to be used with the
To: CF-Talk
Subject: cfstoredproc and cftransaction
What is the best way of handling the following situation.
I have 3 stored procedures I want to call from coldfusion and once all 3
have executed sucessfully, I want to commit them, if any fails, I want to do
a rollback.
Can this be done
Do any of you guys know what the advantages are when using the cf tag
cfstoredproc instead of just executing the stored procedure through a sql
statement? It seems easier and cleaner to me to do it through a sql
statement, but they must have developed the tag for a reason. What am I
missing
301 - 400 of 424 matches
Mail list logo