Toad World® Forums

Data import and Automate in Toad


#21

Put it on "Text" and call your procedure like this:

begin
  my_awesome_procedure;
end;
/

#22

Thank you John, appreciate it.


#23
____    ____  ______    __    __   __.______       _______    ____    __    ____  _______  __        ______   ______   .___  ___.  _______ 
\   \  /   / /  __  \  |  |  |  | (_ )   _  \     |   ____|   \   \  /  \  /   / |   ____||  |      /      | /  __  \  |   \/   | |   ____|
 \   \/   / |  |  |  | |  |  |  |  |/|  |_)  |    |  |__       \   \/    \/   /  |  |__   |  |     |  ,----'|  |  |  | |  \  /  | |  |__   
  \_    _/  |  |  |  | |  |  |  |    |      /     |   __|       \            /   |   __|  |  |     |  |     |  |  |  | |  |\/|  | |   __|  
    |  |    |  `--'  | |  `--'  |    |  |\  \----.|  |____       \    /\    /    |  |____ |  `----.|  `----.|  `--'  | |  |  |  | |  |____ 
    |__|     \______/   \______/     | _| `._____||_______|       \__/  \__/     |_______||_______| \______| \______/  |__|  |__| |_______|

#24

Hi John, regarding ODBC-SQL Server connection to import data from SQL Server database, as you suggested, I wanted to use option. But in ODBC connection dropdwon, I cannot see SQL server to select. Please see the image and suggest.


#25

Windows has a thing called ODBC Administrator. Go in there and set up a connection to your SQL Server database. After that Toad will see it.


#26

Thank you John. I tried and ran into issues, working with sys admin to resolve.
Appreciate your support as always.