Finally got this working...Posting in case this can save someone else some time....
Set FSO = CreateObject("Scripting.FileSystemObject")
Set objFile = FSO.CreateTextFile("C:\vb_output.log", True)
ShowSubfolders FSO.GetFolder("D:\backups")
Sub ShowSubFolders(Folder)
For Each Subfolder in...
Hi All,
First off let me say thanks in advance for taking a look. I have been messing around with the code below that I put together for a few different sources. I'm a Newbie, so knowledge is limited. The end goal is I need a script that sets a root folder and looks through *only folders) under...
stefanhei --
Dead on!!! This is perfect. It is exactly what I was trying to accomplish. using the CASE and loop makes a lot of sense now that I'm looking at the way you constructed this.
Thanks so much for the help :-) .
An update...So I am partially just impatient. The script does come back with:
Declare
*
Error at line 1:
ORA-06500: PL/SQL: storage error
ORA-04030: out of process memory when trying to allocate 16356 bytes
ORA-06512: at sys.dbms_output", line 127"
ORA-06512: at sys.dbms_output", line 113"...
Hello,
I am in the process of writing a script and I'm having some difficulty with using 'GOTO' label. Once I hit return it just sits there. Here is the generic code:
set serveroutput on
DECLARE
var_num1 number(25) NOT NULL := 0;
sql_stmt varchar2(30);
BEGIN
<<BLOCK_CHECK>>
IF var_num1 >...
The code is already written and at this point I'm not reflecting on it and I was wondering what I was missing, or if you simply cannot do this. In the below example, what I was looking to do is this:
SELECT @PKVAL=max(@PK_COL_NAME) from pcattype
Thanks in advance...
Seeking assistance on this one...
Sample Data Set:
rsrc_hr_id rsrc_id ts_id
----------- ----------- -----------
100 200 300
101 200 301
102 201 302
103 201 302
Looking for help with a query to query the data set where it...
I created the following script which works almost perfectly. I wanted a section at the top to modify the physical and logical tablesapce names and teh usernames. It works fine, with the exception of when you run it, it prompts me to enter the 'DATFILE_PHYSICAL' value. Once that is done, the...
I have been working at this for an hour now and with no success.
--Table 1
tblSessions
session_id
login_time
user_name
--Table 2
tblLastLogin
user_name
last_login_date
Currently tblSessions gets cleared by a stored procedure. I don't want to modify any existing objects. I am looking to have a...
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.