Hi,
I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?
For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.
However I am trying to automate the manual process. Any suggestions...
dr3586
Last Activity: Aug 10 '07, 05:27 PM
Joined: Aug 3 '07
Location:
-
Extract data into Excel and enable macros from PL/SQL procedure
-
All,
Nevermind my question, I actually figured it out :) Thanks! -
inserting UNIX variable values into oracle database
Hi,
I am new at this so I apologize if all is not correct. In ksh unix script I am trying to read values from text delimited file into oracle db table. I know that the read from the text file is working so that is not problem.
...
IFS="^^"
exec < smt_output.txt
while read circuit vho ban junk device dvr; do
sqlplus -s usr/passwd <<-EOF
set termout...
No activity results to display
Leave a comment: