Oracle / Stored Proc Issues

[Adrocknaphobia]

So basically we've moved some code from dev to production and on production it blew up. (big surprise right?) well the suprise is that whats blowing up is stored procedure calls that return queries. All other proc call are working like a champ but anything that returns a ref cursor throw an error saying "Invalid number or types of arguments".

As far as my knowledge allows, when you specify a <cfprocresult> that is interpeted as a argument.

So does anyone have any idea why this would be working fine in dev but not production?

I can assure you without posting any code that the calls are being made exactly how they should and the pl/sql is error free. I've had about 5-6 other developers take a look at this and everything codewise is airtight.

[Adam Wayne Lehman]

------------------------------------------------------------
If you don't fake the funk, the funk will fake you.
------------------------------------------------------------

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---