|
|
|
|
|
| Author |
Message |
sha2020 Member
Joined: 09 Jul 2009 Posts: 11 Country: India
|
Posted: Mon Jul 26, 2010 5:14 pm Post subject: Custom SQL issue |
|
|
Hi,
I am trying to execute the below SQL query from wm adapter service(custom sql).
set pagesize 0
set closep |
spool /tmp/df_order_forecast.dat
select * from cdrmgr.forecast_orders;
spool off
but getting error (42000/922) ORA-00922: missing or invalid option,
but the same sql query I can able to run from SQL Developer/ toad.
even I tried to run one by one,
"set pagesize 0" sql in wm adapter service(custom sql), but no use, getting same error
"clntMDD_I_DNF.Db_Operations:invokeScript.
[ADA.1.316] Cannot execute the SQL statement "set pagesize 0". "
(42000/922) ORA-00922: missing or invalid option
"
Can anybody help me on this
Thanks & Regards,
Sha[/b] |
|
| Back to top |
|
 |
sha2020 Member
Joined: 09 Jul 2009 Posts: 11 Country: India
|
Posted: Fri Jul 30, 2010 8:48 am Post subject: Re: Custom SQL issue |
|
|
We solved the issue.
Thanks,
Shami |
|
| Back to top |
|
 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
|
Powered by phpBB © 2001, 2003 phpBB Group
|