cancel
Showing results for 
Search instead for 
Did you mean: 

VC & Oracle (Select Statement )

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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 !

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks for reply , i know that but my problem is can you tell me how can i write a select statement in oracle procedure.