How to get result of select query from oracle in VC

[Former Member]

Dear All ,

I have a application in oracle which insert the data in the oracle database table.

Now i want to show all the data that has been inserted into the database table in my VC application but i don't know how to handle select query in VC.

Regards

Krishan

[Former Member]

Hi ,

if you had the store procedure or Dta service.

first you have to creat a alias in the portal the you have to map that data service to the VC user using data service credentials.

then it will appear in the VC.

Then find your qiery in the VC useing Find data option.

then drag ur qiery and use it for data dispaly.

Regards,

Goivndu

Edited by: Govindu Nagotla on May 8, 2008 11:44 AM

[Former Member]

Hi Goivndu

Thanks for your reply .

I know all those things.

I have created the system & alias for my backend oracle system.

I can also see all the stored procedure that are there in my oracle system.

I just want to know how to write a select query in a stored procedure .

you can insert data , Update data through oracle procedure but i don't think there is any way to get the result of select query in stored procedure .

If you know any way to do that please do let me know .

Regards

Krishan

[Former Member]

We have the same problem.... Did you slove it?