I have one problem.
I would like use UEStudio(UltraEdit) for work vith DB objects. I heve procedure or function or package and I wont run tis code no DB(Oracle).
Everetihing is OK, but I need run this code on meny DB with meny users. For example I have 7 develop DB - every DB vith 3 users - schemas and 4 testing DB with other 2 users - schemas. I create tool DB1-A where DB1 is name of DB and A is name of schema. But I need run procedure on DB1-A,DB1-B,DB1-C...
I can run tool DB1-A,DB1-B,DB1-C. But, for another procedure a need run tull DB-12-G. And this is problem. I can have only 10 tools. I search solution, where I have dynamic parameter in command line in 1 tool. But this is not working how I wont. Parameter %modify% is modifing all line of command line. Not only position, where is write. For example:
C:\oracle\ora81\bin\sqlplus.exe %modify% %f where %modify% is loggin (user/password@database) and %f is name of file. But this not work how I need - how I can . I have idea, that parameter %modify% show dialog, where I write only loggin. After this - Comand line in execute will by C:\oracle\ora81\bin\sqlplus.exe scott/tiger@test test.sql. And - with dhis solution, I can only one tool vith dynamic parameter and I can use this one tool for every databases.
What are you thinking about this function? It is real that will by add in UltraEdit or UEStudio?
Thank for your opinion.
PS: Sorry for my English. I know that is bad
I would like use UEStudio(UltraEdit) for work vith DB objects. I heve procedure or function or package and I wont run tis code no DB(Oracle).
Everetihing is OK, but I need run this code on meny DB with meny users. For example I have 7 develop DB - every DB vith 3 users - schemas and 4 testing DB with other 2 users - schemas. I create tool DB1-A where DB1 is name of DB and A is name of schema. But I need run procedure on DB1-A,DB1-B,DB1-C...
I can run tool DB1-A,DB1-B,DB1-C. But, for another procedure a need run tull DB-12-G. And this is problem. I can have only 10 tools. I search solution, where I have dynamic parameter in command line in 1 tool. But this is not working how I wont. Parameter %modify% is modifing all line of command line. Not only position, where is write. For example:
C:\oracle\ora81\bin\sqlplus.exe %modify% %f where %modify% is loggin (user/password@database) and %f is name of file. But this not work how I need - how I can . I have idea, that parameter %modify% show dialog, where I write only loggin. After this - Comand line in execute will by C:\oracle\ora81\bin\sqlplus.exe scott/tiger@test test.sql. And - with dhis solution, I can only one tool vith dynamic parameter and I can use this one tool for every databases.
What are you thinking about this function? It is real that will by add in UltraEdit or UEStudio?
Thank for your opinion.
PS: Sorry for my English. I know that is bad