Don't know much about the way the users are accessing the oracle db but you could output the reports in html and then access using a browser from windows clients. You would of course then need to be running a web server of some sort but it's not as bad as every user needing to ftp to the...
Sure...;-)
Shipto Customer: 111111111
lineitem 1244444444
number sold 444444
address
city
zip
Shipto Customer: 99987000
lineitem 09999
number sold 999
address
city
zip
Shipto Customer: 111111111
lineitem 678884
number sold 444444
address
city
zip
Wondering if anyone has had to process between 2 different expressions using either awk or sed. I'm looking at finding a line with a specific customer number, then capturing the lines following until it hits the next line containing "customer number" which may or may not be the same...
My question is : When using the set transaction use rollback segment in a plsql procedure, I am receiving an error saying the statement must be the first. I have the following procedure to analyze tables based upon a small window of time and want to use the larger rollback segment but when I...
Thanks...Actually, I granted analyze any to the user executing the procedure and that cured it. Even tho the user had DBA privileges the grant was necessary. Thanks for your reply.
Anyone have any experience using execute immediate? I'm trying to use a procedure to rebuild indexes. Problem is the indexes are SAP flavor with the ~ symbol in them which is giving oracle fits. I've been able to hide the symbol in a normal sqlplus prompt with " ( double quotes ) around...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.