Put it on "Text" and call your procedure like this:
begin
my_awesome_procedure;
end;
/
Put it on "Text" and call your procedure like this:
begin
my_awesome_procedure;
end;
/
Thank you John, appreciate it.
____ ____ ______ __ __ __.______ _______ ____ __ ____ _______ __ ______ ______ .___ ___. _______
\ \ / / / __ \ | | | | (_ ) _ \ | ____| \ \ / \ / / | ____|| | / | / __ \ | \/ | | ____|
\ \/ / | | | | | | | | |/| |_) | | |__ \ \/ \/ / | |__ | | | ,----'| | | | | \ / | | |__
\_ _/ | | | | | | | | | / | __| \ / | __| | | | | | | | | | |\/| | | __|
| | | `--' | | `--' | | |\ \----.| |____ \ /\ / | |____ | `----.| `----.| `--' | | | | | | |____
|__| \______/ \______/ | _| `._____||_______| \__/ \__/ |_______||_______| \______| \______/ |__| |__| |_______|
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.
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.
Thank you John. I tried and ran into issues, working with sys admin to resolve.
Appreciate your support as always.
And can I use the array dml in 11.0.0.116 version? Thank U
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.