Problem with Oracle stored proc result
I'm dealing with an Oracle stored procedure which is coded to only return it's ref cursor if a lookup function within the procedure verifies that the user has rights to run it. If the user doesn't have the correct rights, a message gets returned *instead*. I've coded a cfprocparam to handle the message, and a cfprocresult to handle the ref cursor. But, the ref cursor doesn't get returned if the user doesn't have rights to run the procedure. When this happens, I get the following error from the driver: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 I'm thinking that this is cuz I've coded for a cfprocresult which isn't returned. Can anyone suggest a way around this issue? This is with CFMX 6.1, using the latest JDBC drivers with Oracle 9.2. Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224517 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Oracle stored proc result
Well, I'd generally not design it like that. A stored procedure should do one of two things: return the variable it says it will return or throw an error. I'd probably have it throw a custom oracle error if the person doesn't have permission to run it, and do a try catch in CF to trap that specific error. On 11/17/05, Steve Ray [EMAIL PROTECTED] wrote: I need to amend my post slightly. I referenced the wrong error code. The error I'm getting is actually '[Macromedia][Oracle JDBC Driver]Unsupported data conversion.' Thanks, Deanna. I'll pass your idea by the DBA and see what he wants to do. I'd also thought of moving the permissions logic into it's own small function, calling that and then based on the result, calling (or not calling) the main procedure. Another idea was to return the error message as a ref cursor with the same name as the original cursor (so you get back a ref cur either way, and then check to see what it contains). I think I'd prefer to do something else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem with Oracle stored proc result
2) if the user doesn't have the appropriate privs, raise an error in the proc, and catch that with cftry/cfcatch in coldfusion. Since you can assign an error number and message (RAISE_APPLICATION_ERROR in pl/sql) which will then be available to your cf code through cfcatch. message, you can distinguish between a security error and an other database error. Thanks for everyone's ideas. We've gone with raising an error in the stored proc, and handling it in CFTRY/CFCATCH. That's working well. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224533 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
(no subject)
This is a multi-part message in MIME format. --00DFBEAD50FEA6C9CDCB798B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit unsubscribe cf-talk [EMAIL PROTECTED] --00DFBEAD50FEA6C9CDCB798B Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:Ray;Steve tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International;Team Hi-Fidelity version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --00DFBEAD50FEA6C9CDCB798B-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
processing umlaut characters
This is a multi-part message in MIME format. --1B56CACAC542608BA32EBF87 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi. One of our developers here is having a problem with , and I'm wondering if any of you have come across this and found a solution. It's on a edit form which has a dropdown select box; the item in the dropdown which matches the value in the database table should be selected when the record is brought into the form. One of the values (name of a company) has an umlaut (double dots, like a colon turned on it's side) above an "o". We're running a "nocase" -type statement on it for the comparison, and CF is not seeing the umlaut. The only mention I can find in Allaire's forums re: umlauts has to do with Verity and the german language module. That obviously wouldn't help here. If any of you have any suggestions or workarounds, I'd love to hear 'em. Thanks a lot. Steve Ray Matrix Group CF-Talk wrote: CF-TalkSat, 14 Oct 2000 Volume 1 : Number 58 In this issue: Re: CF-Talk V1 #57 Re: Wierd CFLOCATION error Re: OT: Thawte/ SSL provider help - soln RE: CFX Tags Registering virtual hosts in IIS -- Date: Fri, 13 Oct 2000 19:33:46 -0700 From: "Michelle Plahmer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: CF-Talk V1 #57 Message-ID: s9e763ac.034@gwisegw2 I will be out of the office Monday, October 16 through Friday, October 20. = I will be checking my voicemail and e-mail. -- Date: Fri, 13 Oct 2000 22:53:35 -0400 From: "David Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Wierd CFLOCATION error Message-ID: 006a01c03589$f3769340$[EMAIL PROTECTED] There is a custom tag that is called CFMAGICCOOKIE that allows you to use a cookie and a cflocation together. I've used it in a very limited basis with success. I have no idea how robust it would be. Dave - Original Message - From: Bill Killillay [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 13, 2000 4:51 PM Subject: RE: Wierd CFLOCATION error Sure ya can, the cookie just won't be set *grin* You cannot use cfcookie in the same template as cflocation .. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Date: Fri, 13 Oct 2000 20:44:35 -0700 (PDT) From: cf kaizen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: paul smith [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: OT: Thawte/ SSL provider help - soln Message-ID: [EMAIL PROTECTED] Thanks everyone for your replies. My oversight was that I had to start off first with my ISP - in my case Virtualscape, to get the CSR to deliver to Thawte in THEIR step 1. My apoligies for the mixup. Tx again, Andy --- paul smith [EMAIL PROTECTED] wrote: The link is on the page at the URL below. Right above the big "ENROLL" gif ;-) best, paul __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ -- Date: Sat, 14 Oct 2000 02:01:04 -0400 From: [EMAIL PROTECTED] (lsellers) To: [EMAIL PROTECTED] Subject: RE: CFX Tags Message-ID: [EMAIL PROTECTED] There is a tag in the Developer's Exchange at Allaire called Auto_Add_CFX... I've used it to add CFX on my virtual server. I wrote it. It requires CFREGISTRY to be turned on. It directly adds the required entires to the registry to "register" a CFX tag. So... if you can use CFREGISTRY, you can add them yourself. Of course... you should probably be expected to be kicked off their systems if they find out you've done that. :-) But it might be possible. --min -- Date: Sat, 14 Oct 2000 11:45:48 +0200 From: WebSite CFTalk [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: Registering virtual hosts in IIS Message-ID: [EMAIL PROTECTED] Hello Running CF 4.5.1 Enterprise on NT 4.0 with IIS4.0 We need to add virtual hosts to the webserver as company1.website.no / company2.website.no etc "on the fly". I'm sure this is not a very difficult task, but if anyone have already done it, any customtag etc, I would be grateful for pointers. Thanks Helge Hetland -- End of CF-Talk V1 #58 * -- Archives: http://www.mail-archive.com/cf-talk@
Possible ip address conflict btwn CF and Lyris
This is a multi-part message in MIME format. --883A582812D5769035BBE48D Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi. We've installed the Lyris mail list server on an NT box which also has CF Professional 4.5. I'm wondering if any of you who have this setup have encountered a problem that we're currently having. This box has several ip addresses on it, so that we can host multiple domains. CF and Lyris both run just fine, thanks very much, but when you attempt to get to the Lyris admin pages (which is via a browser on port 80), they refuse to come up. When we stop the CF server service, the admin pages come up just fine. We are wondering if CF somehow gets bound to the default ip address of the box in such a way that it disallows other requests to that address on port 80. All of our websites on that box are set up to respond to ip addresses other than the default, so we're not encountering this problem btwn CF and the web server. The ip conflict theory frankly doesn't make sense to me (even though I came up with it), but I haven't been able to come up with anything else. I don't yet know whether you can tell Lyris to use a different port for it's admin pages. Any ideas or clues would be great. Thanks much. Steve Ray Matrix Group --883A582812D5769035BBE48D Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --883A582812D5769035BBE48D-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF/Solaris on Intel
This is a multi-part message in MIME format. --99CC7CE2EBD545C6DABCF674 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Larry - Thanks, and I love the star trek tag line. Goes right along with your comments. Does Sun (or someone else) make a converter for the monitor connection? All of the Sun monitors that I've ever worked with have a very different port connection than the standard pc monitor cables. For that matter, what about sync rates and that sort of thing? Any compatibility issues there? Thanks again for your comments. Steve "Larry W. Virden" wrote: From: Dave Watts [EMAIL PROTECTED] Your best bet is to bite the bullet, and go get a Sparc box. Fortunately, you don't have to get a good Sparc box. You can get one of the Ultra 5 workstations, which run about $4,000 or so. And that price is including a monitor. If you just want to use one of your existing monitors, the price is around $2200 - see URL: http://store.sun.com/webconfig/BuildConfig.jhtml;$sessionid$PRZINPQAABB55AMTA1ESQCT5CJ1K -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- --99CC7CE2EBD545C6DABCF674 Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --99CC7CE2EBD545C6DABCF674-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF/Solaris on Intel
This is a multi-part message in MIME format. --7044766746D9E10C0B119316 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi. We have a client who uses Solaris on SPARC boxes, and we need to develop a CF app for them. From what I can tell, Solaris for CF only works on SPARC. Problem is, we don't have a SPARC. Can CF for Solaris be put on an Intel box running Solaris? If not, what do you suggest? Running the Linux version? Are there any differences btwn the CF/Linux and CF/Solaris versions which would present problems when we migrate the application onto the client's SPARC? Thanks for any clues. Steve Ray --7044766746D9E10C0B119316 Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --7044766746D9E10C0B119316-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problems indexing pdf files
This is a multi-part message in MIME format. --8ECF8EDFEBE7B3C6865C5A24 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, folks. One of our programmers is having problems indexing pdf's into a Verity collection. I was able to do it a couple of weeks ago for a different project w/o a problem, and don't really see anything wrong in his code. He's been able to index other file types just fine as part of the same application. Have any of you ever run across problems with indexing pdf's? We've tried blowing away the collections and starting over, to no avail. Any ideas would be greatly appreciated. Thanks. Steve Ray Matrix --8ECF8EDFEBE7B3C6865C5A24 Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --8ECF8EDFEBE7B3C6865C5A24-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Problems indexing pdf files
This is a multi-part message in MIME format. --87D131FD97B1245DF2C95B6D Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hey, Peter. No errors, it's just coming back with no results. The pdfs are in the correct directory, and they don't have graphics in them (the guy who's having the problem said that he saw something about problems indexing pdfs with graphics, or ones which were scanned). Other collections he created work like a charm. Thanks for any clues. Steve Peter Tilbrook wrote: What sort of errors are you getting? Is CF actually indexing anything at all? Hi, folks. One of our programmers is having problems indexing pdf's into a Verity collection. I was able to do it a couple of weeks ago for a different project w/o a problem, and don't really see anything wrong in his code. He's been able to index other file types just fine as part of the same application. Have any of you ever run across problems with indexing pdf's? We've tried blowing away the collections and starting over, to no avail. Any ideas would be greatly appreciated. Thanks. Steve Ray Matrix --87D131FD97B1245DF2C95B6D Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --87D131FD97B1245DF2C95B6D-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
thanks for the ldb answers
This is a multi-part message in MIME format. --F1B6D0D7F68CDBC36FA1EDBD Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thanks to everyone out there who offered suggestions as to how to rid oneself of .ldb files. Fantastic responses. I really appreciate it. Steve Ray Matrix --F1B6D0D7F68CDBC36FA1EDBD Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --F1B6D0D7F68CDBC36FA1EDBD-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Access .ldb files
This is a multi-part message in MIME format. --EF061FD2679FC2B0B93A1855 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hey, I know this is slightly off-topic, but does anyone know how long .ldb files generally hang around (provided you don't have the database open in Access)? There never seems to be a rhyme or reason... Thanks. Steve Ray Matrix --EF061FD2679FC2B0B93A1855 Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --EF061FD2679FC2B0B93A1855-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
IE 5 formfield submission problem
This is a multi-part message in MIME format. --133828C2B051D9148A9E08F6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi. This may be slightly off-topic... We have a form in a CF app which loses all of it's data upon submission, *if* you've forgotten to fill in a required field. A javascript pop-up comes up informing you of the required field, you hit ok, and then wam! you get an IE page which sez: Warning: Page has Expired The page you requested was created using information you submitted in a form. This page is no longer available. As a security precaution, Internet Explorer does not automatically resubmit your information for you. To resubmit your information and view this Web page, click the Refresh button. You hit refresh, and all of the fields in the form are now blank - none of the fields retained the values you typed in them. And yet (of course) we have another form in the same app which does not have this problem. The form comes back up, and the fields you filled in still display whatever info you typed in them. All of the javascript in the these two files are identical in every way. This only happens in IE, and I'm pretty sure that this is a well-known problem. I'm wondering if any of you have come up with a workaround. I'd come up with a session variable fix, but the client wants the app to behave in a consistent way in response to errors, and I can't blame them there. Any ideas, I'd love to hear 'em. Thanks. Steve Ray Matrix Group --133828C2B051D9148A9E08F6 Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --133828C2B051D9148A9E08F6-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
