Defining a variable more 240 in legnth using DEFINE
781626Jun 27 2010 — edited Jun 28 2010Hi All,
I need to define a variable that has more than 240 char in length. But I am getting an error saying that the char string is more than 240 in length. Is there any work around for this. The purpose is to caliculate metadata about DB users. I have wrapper script which calls an other 23 sql scripts to get info of tables, indesex, partitions..etc in each one of the script. I have to define the a variable SCHEMA_NAME="'a', 'b', 'c'" where a, b, c..... are usernames in the DB. As there are about 100 users in DB, I could not assign all the 100 users to one single variable. This script needs to be run against many DBs in our environment. I can thinkof two options.
1).splitting this single variable into multiple variables and call all of them in each script
2). Remove the wrapper script and make a single script instead of 23 small scripts and past all the schema names in WHERE condition instead of calling a user defined variable.
But as these scripts need to be run against multiple DBs, I am looking for some smart solutions which can reduce work to achieve the same result. Because in above 2 cases I dont see any benfit of having this script, its like executing the 23 commands in place of 1 script. Please advice me. Thanks in advance