| Call SQLPLUS ok, but then SPOOL problem [message #80192] |
Wed, 21 August 2002 08:44  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
Hey All, thanks for all your responses thus far...
I am able to call SQLPLUS now, while appending the username,pwd,connect and also now I can run the script after opening sqlplus, all implicitly.
My problem now is, I'm trying to spool all of select procedure that is executed when sqlplus is open, to a file. I have tried two things... the spool command in the command line behinde the button that calls sqlplus...
(before)
host('PLUS80W.EXE '||:user_name||'/'||:pwd||'@'||:connect_string||' '||'@PRODUCE_PUBL_EXT.sql');
(after)
host('PLUS80W.EXE '||:user_name||'/'||:pwd||'@'||:connect_string||' spool PRODUCE_PUBL_EXT.txt '||'@PRODUCE_PUBL_EXT.sql');
--this didn't work
and then I tried to put it into the procedure...
set echo off
set heading off
set pagesize 9999
set newpage 0
set linesize 300
spool PRODUCE_PUBL_EXT.txt;
select RPSB_REGION||'|'||RPSB_PRODUCT||'|'||RPSB_FETX_1||', '||RPSB_FETX_3||', '||RPSB_FETX_3||', '||RPSB_FETX_4||', '||RPSB_FETX_5||', '||RPSB_FETX_6||', '||RPSB_FETX_7||', '||RPSB_FETX_8
||'|'||RPSB_DATES||'|'||RPSB_RATES||'|'||RPSB_COMMENTS AS "EXTRACT"
from REPORT_PUBL_SF_BODY
/
but it doesn't seem to be spooling, or even executing the spool command when sqlplus opens... but no error???
Suggestions would be SO appreciated... thanx
~ T ~
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
