Re: Oracle/ASP hanging
From: s_gemberling <s_gemberling_at_yahoo.com>
Date: 26 Aug 2003 10:05:19 -0700
Message-ID: <1e64ee35.0308260905.535144ec_at_posting.google.com>
Date: 26 Aug 2003 10:05:19 -0700
Message-ID: <1e64ee35.0308260905.535144ec_at_posting.google.com>
Hi Ross -
Thanks again. (I knew what you meant about that "Set" thing...) I commented out the on error resume next and I get the "Invalid SQL statement" error on the cmd.Execute line. I put an exception handler in my package and it doesn't return anything. I ran the package in SQL Plus and it runs fine. I am completely baffled! I even changed the package to a more simple select (Select * from PRJMGMT.work_orders;) It still doesn't work. The confusing part is that other thatn the table/package/procedure names, I have several other functions that do the same exact thing and they all work fine!!! (Scratching head...) Received on Tue Aug 26 2003 - 19:05:19 CEST