Data import and Automate in Toad

Toad for Oracle & DevOps Toolkit
21

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

begin
  my_awesome_procedure;
end;
/
22

Thank you John, appreciate it.

23 
____    ____  ______    __    __   __.______       _______    ____    __    ____  _______  __        ______   ______   .___  ___.  _______ 
\   \  /   / /  __  \  |  |  |  | (_ )   _  \     |   ____|   \   \  /  \  /   / |   ____||  |      /      | /  __  \  |   \/   | |   ____|
 \   \/   / |  |  |  | |  |  |  |  |/|  |_)  |    |  |__       \   \/    \/   /  |  |__   |  |     |  ,----'|  |  |  | |  \  /  | |  |__   
  \_    _/  |  |  |  | |  |  |  |    |      /     |   __|       \            /   |   __|  |  |     |  |     |  |  |  | |  |\/|  | |   __|  
    |  |    |  `--'  | |  `--'  |    |  |\  \----.|  |____       \    /\    /    |  |____ |  `----.|  `----.|  `--'  | |  |  |  | |  |____ 
    |__|     \______/   \______/     | _| `._____||_______|       \__/  \__/     |_______||_______| \______| \______/  |__|  |__| |_______|
1 Like
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.
image

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.

27

And can I use the array dml in 11.0.0.116 version? Thank U

28

If you have any type of LOB column, array DML is not allowed.
We had a bug for a little while (could have been 11.0, I can't remember for sure) that timestamp/interval prevented array DML, but this is fixed in newer versions.

Other than that, Array DML should work. If that's not it, please post some details in a new thread. This thread has enough different subjects already. :smiley: