Recent content by Brad P

set feedback off set heading off set pages 0 The following runs fine in 10g sql plus but I want to run this in pl/sql as a procedure on 11g now. I need some guidance on the coversion of spooling and using @ commands... thanks in advance, brad ------- set lines 200 spool...

Thanks, that's the solution. I placed single quotes around all the occurances of single quotes... thanks again... b

In a view, trouble with single quotes... I'm getting a pls-00103 encounterd the symbol "COUNTY" when expecting one of the following... on the line as follow: , NVL(RTRIM(SUBSTR(C.ROW_DATA,1,30)),'County Deleted Value') AS ADR_VRF_SRC_DESC The vendor shares this code and I'm trying to compile...

I need an example to show me how to execute 'bat' files on pl/sql. The bat files are simple copy or delete dos commands. I'm running windows server 2003. If there is a alternative way to running bat files, I'm open to windows scripting or vb.net or vb6. We are a small shop running one db on 11g...

I'll check that out. Thanks, The goal is to run a scheduled job on my 11g with multiple steps of which one of them is to upload the data.

I'm uploading a 80gig, 500 text files into 500 tables. Then applying primary keys, foreign keys and indexing. Is external tables a viable option?

I would like to create a procedure to call/execute sqlldr in pl/sql. Currently, I'm running a bat file in a dos window. Am I able to call/execute a bat file in a pl/sql procedure? Thanks in advance... bproffitt