I need to compile the oracle function through asp .net
-
I have an oracle function.It works fine when it is static. If i create the same function dynamically though asp .net code the error comes. I tried this code ALTER FUNCTION Group_concat COMPILE This code works manually.But in the run time it does not work. Give me solution if anyone knows. Thank you
-
I have an oracle function.It works fine when it is static. If i create the same function dynamically though asp .net code the error comes. I tried this code ALTER FUNCTION Group_concat COMPILE This code works manually.But in the run time it does not work. Give me solution if anyone knows. Thank you
froxy wrote:
If i create the same function dynamically though asp .net code the error comes.
What error? And what code? (Describing the code does not count)
Recent blog posts: *Method hiding Vs. overriding *Microsoft Surface *SQL Server / Visual Studio install order My Blog
-
I have an oracle function.It works fine when it is static. If i create the same function dynamically though asp .net code the error comes. I tried this code ALTER FUNCTION Group_concat COMPILE This code works manually.But in the run time it does not work. Give me solution if anyone knows. Thank you
Few issues: - why do you want to compile the function from code. You may run into trouble with that - most likely your connection hasn't got enough privileges - if you need to create a pl/sql block at runtime, perhaps you could use anonymous blocks
The need to optimize rises from a bad design. My articles[^]