Hi

[#1]

I have a stored procedure in my QlikView named SQL.txt, in that Stored Procedure i have like:

Select * from table

as

Create Dummy Data;

in the above Stored Procedure is a dummy example for making a table in database, Now what i want to do is that the SQL Stored Procedure script should run first on the database and after that the LOAD Statement what so ever should be executed in Edit Script.

Have you any solution for it.

Regards,

Khalid

[#2]

Not sure if you are looking for this or not but just to give you an idea

1. put following code in file run_procedure.sql

EXECUTE yourprocedurename;
EXIT;

2. put following code in loaddata.bat file

"C:\oracle\ora92\bin\sqlplusw.exe" username/password @sqlfilepath\run_procedure.SQL

"C:\Program Files\QlikView\Qv.exe" /r "your QVW file path\xyz.qvw"

3. run batch file. This will run procedure first and the it will load data in qlikview file.