on 11-05-2007 7:51 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you try the same approach using an SQLQuery in "command" mode?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
6 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.