I hope you can help me with this because I am out of ideas...
I am trying to pass a structure into an Oracle procedure and have had no luck… does anyone know how to pass a complex data type into an Oracle database?
My idea was to pass in two structures, the first representing information the user submitted on a page, and the second, from the ColdFusion session describing who the user is. The procedure would then return a few variables describing what happened.
I could break the structures out into simple data types… but if I later decide to pass additional information from the CF session to Oracle, I will have to update every ColdFusion procedure call and every procedure on the database.
Any help or advice is much appreciated!
I am using ColdFusion 7 and Oracle 10g.
Thanks,
Dan