Recent content by janaka12

Hi We deal in financial solutions for stock exchanges mainly the database management aspect. We have been developing front ends(Oracle Forms) as well as back ends(PL/SQL) in oracle. We are hoping to move to J developer for building our front ends. The problem we are facing now is that when...

Hi again, I was able to cater for any number, type of in parameters to a procedure and build the sql statement by concatanating the in parameters dynamically. I need a method to do the same for the out parameters as well without giving them in the returning into clause. This is because...

Since I know the maximum possible variables which will be needed for any procedure/function, i can make a nested if statement even though it may become very long. However i guess using the long nested if statements would be more efficient than creating the nested if statement dynamically and...

Thanks for the help. I tried it out using the method you have suggested and it works fine. The drawback in my solution is that i assume knowing the probable variables for use in a procedure/function. (Since i use them in the long nested if statements) Thanks again for helping me out.

Hi , We have a table to record all the procedures/functions that a particular transaction needs to call. The user can opt to use/not to use these procedures/functions for a particular transaction. These procedures/functions are predefined and not added dynamically. The user only has the option...