A very simple question

[chikkodi]

A very simple question

I have a main .sql file from which I call a couple of other .sql files

example

setup_main.sql
@setup_one
@setup_two
@setup_three

so, during our system installation, we just run setup_main.sql. That takes care of all other setups.

Now, my question is, I have some variables that are used in some setup scripts. Is there a way by which I can initialze those variables in setup_main.sql itself and pass them as arguments to the other setup scripts ? Otherwise, the person installing the sofware has to go to each of the setup scripts and change them. I am trying to avoid that.

So, I want my setup_main.sql to look like:

setup_main.sql
@setup_one host_name
@setup_two user_name
@setup_three

I was thinking may be I have to create stored procedures for sqls to access input variables. Is there a better way ?

Thanks

[jdjoshi]

Hmmm.

Yes. You may initialize some variables in main.sql and pass
them as a parameter in all the subsequent sqls. What you may
have to do in all the subsequent sqls is put a reference to these variables by using them as &var1, &var2 etc.

Then, when u are invoking these setup_one, setup_two sqls, invoke them as :
@setup_one var1 var2
@setup_two var1 var2

That should do it.

Ofcourse, you can write PL/SQL procedures also.

Happy coding !!!

[chikkodi]

Works great !

Thankyou. You saved me a lot of time !