sql file

[Buky]

How could I execute an exported procedure (in a local .sql file), through a
VB or ASP command?

For example, I saved a procedure or a package on my computer, and I would
like to put it into a remote database.
I know there's an @ command, but it seems it's not just that simple. I would
like to execute that in VB app. or asp web page.

tnx,

Buky

[x]

Re: sql file

In vb, something like:

Shell "sqlplus -s user/pass@database @myfile.sql"