on 04-18-2008 12:44 PM
Dear All
I have implemented a feedback form in my Portal and the data which the portal gets is saved in oracle database .
Now my problem is i want to show the Admin of the portal what feed back we got
So I want to fire a select statement into oracle database but i don't know how to do that.
Can any one tell me how to get the result of select statement in VC from oracle database
Regards
Krishan
Krishan,
The following link may help you
http://www.exampledepot.com/egs/java.sql/CreateProcedureAndFunction.html
regards,
Ahmed Salah
Donot forget to reward points if helpfull !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
krishan,
You should define your database in the Portal and give it an alias.
You will have to use the JDBC connector.
After doing so you will have to create a stored procedure to select your data from the Oracle DB.
You will be able to access the oracle DB from the vsual composer by means of Stored procedure.
Please get back to me if you need more help.
Regards,
Ahmed Salah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.