Recent content by TimGoff

Dave, I'm only calling the procedure from SQL*Plus as a test. Normally it will be called from within another stored procedure. I'm looking to get the directory contents of a folder which sits on the Oracle server rather though - don't know if that makes a difference? Thanks for your continued...

Dave I would like to run the routine from inside a PL/SQL stored procedure (the files are passed to another routine, and the data imported into the db.) Tim

Hi I tried running it and receive the following error. Would you have any idea what the problem is? SQL> exec get_dir_list( '/MRU_MUSIC_FILE' ); begin get_dir_list( '/MRU_MUSIC_FILE' ); end; ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException ORA-06512...

Thanks, never tried it before but will give it a go...

jimirvine, Thanks for your quick response. I'm running 9i unfortunately at the moment - I believe I read dbms_backup_restore.searchfiles is only available in 10g? Thanks, Tim

Hello, Does anyone know how I could use PL/SQL to find all the file names that are in a specific folder? Thanks, Tim

Hello, I'm using FtpWebRequest - I can succesfully FTP files, but can't find a way to set the Proxy server. I've got this far and got stuck: Dim ProxyServer As IWebProxy Dim webProxyUri As New Uri("ftp://my_ftp_proxy") ProxyServer.Credentials = webProxyUri result.Proxy = ProxyServer Any...

Kalisto, Thanks for your reply. Where can I find the Listitem object? Tim

Hello all, I'm currently migrating some code from VB6 to .NET v2. In VB6 I populated the list box with the code below, using Channel_ID as the index. I can't find a way though to do this in .NET. Has anyone any thoughts? lstListBox.AddItem !Channel_Name...

Hi Has anyone got sample code on how to read an XML file using PL/SQL? Thanks in advance Tim

Hi I have a fairly large Access db (about 1GB) that has been working absolutely fine. Now everytime i attempt to edit some code, or insert new code it deletes the line and gives me an 'out of memory' error Looking at the help it says reduce the amount of public variables - I have 10 of them...

Top man - thanks very much Golom. Tim

Hello, I open a ADODB recordset using the following SQL (using the connection string CurrentProject.Connection), and the recordset is NULL. If a paste the SQL into an Access query and run - it returns 4 records. I don't understand - is anybody able to shed light on this please? Thanks in...

Tharg, Many thanks for all your comments, I've read through a few times and I've learnt alot from what you've said. The reason I wrote the code with SELECT DISINCT is that SELECT DISTINCT READY_FOR_TX_CODE INTO v_ready_for_tx FROM PROG_MEDIA_SEGMENT WHERE PROG_MEDIA_ID =...

Hello, I use the following function in a query. It doesn't return any result in the field - but also doesn't return an error. Can you see what's wrong? Thanks in advance Tim create or replace package body UKTV_TOOLS_PKG is FUNCTION Get_Ready_For_TX_Flag(v_prog_media_id NUMBER) RETURN...