Skip to main content
E
EmmanuelRuiz
Inspiring
September 22, 2006
Question

Convert Oracle Stored procedure back to cfquery

  • September 22, 2006
  • 1 reply
  • 331 views
I have this Oracle stored procedure that I would like to convert back to a cfquery tag. Can anyone guide me and explain tweaks/changes necessary? (Enclosed is the Oracle Stored Proc)

Thanks
Em
This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
September 22, 2006
I would process all that if/else logic first to build all or part of the eventual sql. Then you output the variable, probably using the preservesinglequotes function inside the cfquery tag.
P
paross1
Participating Frequently
September 22, 2006
Something like this perhaps?

Phil
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices