How to run an Oracle Script File

[sidnooradarsh]

Hi,

Please anybody tell me how to run an Oracle script file (*.sql file) from Query template.

In SQL*Plus we run a script file as @Script_file_name.sql

how do we do it in Query Template.

[salvatore_castro · Accepted solution]

Adarsh,

Use Business Logic....

Use the file loader (File IO -> Flat File Parser) to get the contents of the sql file. Then pass the loaded contents as a string into the SQL Query action into the Query parameter. Hope this helps.

Sam

[Former Member · Accepted solution]

Adarsh,

Create a fixed query with only '[Param.1]' as text,

Then as mentioned by Sam, load the script and pass the text to this param.

Regards

Rupesh

[Former Member]

I have this BLS that executes the JCO within a few minutes. The problem is this bapi produces 165,000 rows that needs to be INSERT into an Oracle table. I use a REPEATer to read the Response from the BAPI and execute a SAP Query by INSERTing 1 row at a time. is there anyway I can load 165,000 rows at one time??

[salvatore_castro]

Dave,

Please only post your question in one thread at a time....

[|]

Sam

[Former Member]

sorry about the dup

[Former Member]

Did you try the same approach using an SQLQuery in "command" mode?