Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Oracle overloaded Procs that return ref cursors

Community Beginner ,
Jul 23, 2007 Jul 23, 2007
I have two Oracle stored procedures that are overloaded. Each returns a reference cursor and works fine independently, so long as the other procedure is removed from the package. I am passing the IN parms in the CFProcParam tags named with the dbvarname attribute and am receiving the result in the CFProcResult tag. I've update CF to Hotfix 2 and am using the Oracle driver include with CF. Still no luck with the overloaded procs. Is this possible in MX 7?

Any help is greatly appreciated.

TOPICS
Database access
597
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Mentor ,
Jul 24, 2007 Jul 24, 2007
In the past, I have gotten PLS-00306: wrong number or types of arguments error messages when attempting this. In fact, I left a note on the cfprocparam tag page back in May 2006, so if you are getting the same error, this may still be a bug.

My note:
You still can't use overloaded Oracle procedures if your stored procedure uses ref cursors, as it throws a [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments error. I have seen bug number 53122 associated with this problem back in MX 6.1, but it is still not supported.

Phil
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 24, 2007 Jul 24, 2007
LATEST
Yes, that's the error. Any idea if it's been addressed in Scorpio?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources