Package required to connect to SQL Plus

I have a query which need to be run on SQL plus by connecting to a Oracle database. Is there any specific activity for this purpose? Also, there are some keyboard activities which will need to be performed on the UI. Kindly help on this.

@Santa_Krish

for db activities we have activities related to DB and no need to use frontend or ui

cheers

Hi @Anil_G ,

Yes, I have used database activities before to execute queries, but in this specific case , the script has to be run in SQL plus. So based upon the output from the query, enter button will have to be clicked and so on. So I was looking for any ways to do this since by using database activities we can only execute the query and not perform keyboard actions based upon the values on the screen

@Santa_Krish

Whta happens if we click enter and all?

it is not recommended to use this for ui as it is unstable

you can still try but not a straight forward one

cheers

1 Like