I have a need to store an oracle function in a CLOB. When a user hits a certain page I want to pull the function out of the CLOB and run it through an ASP page. How do I go about doing this? I have been trying to get it to run for a while now, but I just can't get it to return anything.
A little background:
I have to put it into a CLOB because we are not allowed to add anything to the database without first going to the "DBA". Our DBA is an outside company that takes to long to get our request filled, so we are trying to sidestep the process.
The functions are going to be on a per course basis, so there will be a lot of them, and they can get added daily. If we can get it to work this way it would make life a lot easier.
Thank you for any and all help.
A little background:
I have to put it into a CLOB because we are not allowed to add anything to the database without first going to the "DBA". Our DBA is an outside company that takes to long to get our request filled, so we are trying to sidestep the process.
The functions are going to be on a per course basis, so there will be a lot of them, and they can get added daily. If we can get it to work this way it would make life a lot easier.
Thank you for any and all help.