cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Views in IDT

former_member185138
Participant
0 Kudos

Hi,

I am unable to insert the oracle views in IDT.

Is it not available in IDT.

Also are the stored procedures or cursors can be imported to IDT or not?

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member185138
Participant
0 Kudos

Thanks all for the response.

Former Member
0 Kudos
former_member182521
Active Contributor
0 Kudos

Hi S J,

Similar to tables, views should also be available in IDT as long as you are granted either Select. . Kindly check whether the user used in BO connection has appropriate right in oracle end (Select). 

You can also use procedures in universe independently not from a oracle package. as long as your cursor is written with in a procedure or in a function you can use them

Regards

Mani

former_member185138
Participant
0 Kudos

It's somehow visible now.

But the second point is still unclear are the stored procedures or cursors can be imported to IDT?